/*
        @author: 刘炳锐
        @date: 2021-09-20
        @function:创建教务管理系统表空间
*/
create bigfile tablespace Educational_information
datafile 'Educational_information_data.dbf' size 50M 
autoextend on next 10M maxsize 100M;
-- 创建用户
/*
        @author: 刘炳锐
        @date: 2021-09-22
        @function:创建管理员用户
*/
create user Administrator identified by Administrator
default tablespace Educational_information 
quota unlimited on Educational_information;
/*
        @author: 刘炳锐
        @date: 2021-09-22
        @function:创建教师用户
*/
create user Teacher identified by Teacher
default tablespace Educational_information
quota unlimited on Educational_information;
/*
        @author: 刘炳锐
        @date: 2021-09-22
        @function:创建学生用户
*/
create user Student identified by Student
default tablespace Educational_information
quota unlimited on Educational_information; 
-- 创建表 
/*
        @author: 刘炳锐
        @date: 2021-09-22
        @function:创建院系表
*/
create table department
(
   dno                nchar(4),
   dname              nvarchar2(50)         not null,
   constraint PK_DEPARTMENT primary key (dno)
)tablespace Educational_information;
-- 给院系表及其字段添加注释
comment on table department is '院系信息表';
comment on column department.dno is '院系编号，院系表的主键';
comment on column department.dname is '院系名称';
/*
        @author: 刘炳锐
        @date: 2021-09-22
        @function:创建专业表
*/
create table major
(
   mno                nchar(6),
   dno                nchar(4),
   mname              nvarchar2(50)         not null,
   constraint PK_MAJOR primary key (mno),
   foreign key (dno) references department(dno)
)tablespace Educational_information;
-- 给专业表及其字段添加注释
comment on table major is '专业信息表';
comment on column major.mno is '专业编号，专业表的主键';
comment on column major.mname is '专业名称';
comment on column major.dno is '专业所属的院系编号，专业表的外键';
/*
        @author: 刘炳锐
        @date: 2021-09-22
        @function:创建班级表
*/
create table stu_class
(
   classno            nchar(8),
   mno                nchar(6),
   classname          nvarchar2(30)         not null,
   constraint PK_CLASS primary key (classno),
   foreign key (mno) references major(mno)
)tablespace Educational_information;
-- 给班级表及其字段添加注释
comment on table stu_class is '班级信息表';
comment on column stu_class.classno is '班级编号，班级表的主键';
comment on column stu_class.classname is '班级名称';
comment on column stu_class.mno is '班级所属专业编号，班级表的外键';
/*
        @author: 刘炳锐
        @date: 2021-09-22
        @function:创建学生表
*/
create table student
(
   sno                nchar(10),
   classno            nchar(8),
   mno                nchar(6),
   dno                nchar(4),
   sname              nvarchar2(10)         not null,
   sex                nchar(1),
   birthday           date,
	 enro_year					date,
   mobile             nchar(11),
   natnm              nvarchar2(100),
   spassword          nvarchar2(16),
   constraint PK_STUDENT primary key (sno),
   foreign key (classno) references stu_class(classno),
   foreign key (mno) references major(mno),
   foreign key (dno) references department(dno)
)tablespace Educational_information;
-- 给学生表及其字段添加注释
comment on table student is '学生信息表';
comment on column student.sno is '学生学号，学生表的主键';
comment on column student.classno is '学生所在班级编号，学生表的外键';
comment on column student.mno is '学生所属专业编号，学生表的外键';
comment on column student.dno is '学生所属院系编号，学生表的外键';
comment on column student.sname is '学生姓名';
comment on column student.sex is '学生性别';
comment on column student.birthday is '学生出生日期';
comment on column student.enro_year is '学生入学年份';
comment on column student.mobile is '学生手机号';
comment on column student.natnm is '学生籍贯';
comment on column student.spassword is '学生登录密码';
/*
        @author: 刘炳锐
        @date: 2021-09-22
        @function:创建学期表
*/
create table term
(
   termno             smallint,
   termname           nvarchar2(15),
   constraint PK_TERM primary key (termno)
)tablespace Educational_information;
-- 给学期表及其字段添加注释
comment on table term is '学期信息表';
comment on column term.termno is '学期编号，学期表的主键';
comment on column term.termname is '学期名称';
/*
        @author: 刘炳锐
        @date: 2021-09-22
        @function:创建教材表
*/
create table teaching_material
(
   tmno               nchar(5),
   tmname             nvarchar2(100)        not null,
   tm_author          nvarchar2(30)         not null,
   tm_press           nvarchar2(30)         not null,
   constraint PK_TEACHING_MATERIAL primary key (tmno)
)tablespace Educational_information;
-- 给教材表及其字段添加注释
comment on table teaching_material is '教材信息表';
comment on column teaching_material.tmno is '教材编号，教材表的主键';
comment on column teaching_material.tmname is '教材名称';
comment on column teaching_material.tm_author is '教材作者';
comment on column teaching_material.tm_press is '教材出版社';
/*
        @author: 刘炳锐
        @date: 2021-09-22
        @function:创建课程表
*/
create table course
(
   cno                  nchar(10),
   dno		        nchar(4),
   termno	        smallint,
   tmno		        nchar(5)	not null unique,
   cname                nvarchar2(30)   not null,
   credit               number(4,1),
   TotalPeriod	        number(3,0),
   Assessmethod	        nvarchar2(4),
   Courseattribute	nvarchar2(2),
   WHETHEREXAM		nvarchar2(1),
   constraint PK_COURSE primary key (cno),
   foreign key (dno) references department(dno),
   foreign key (termno) references term(termno),
   foreign key (tmno) references teaching_material(tmno)
)tablespace Educational_information;
-- 给课程表及其字段添加注释
comment on table course is '课程信息表';
comment on column course.cno is '课程编号，课程表的主键';
comment on column course.dno is '开课院系，课程表的外键';
comment on column course.termno is '开课学期，课程表的外键';
comment on column course.tmno is '课程选用教材，课程表的外键';
comment on column course.cname is '课程名称';
comment on column course.credit is '课程学分';
comment on column course.TotalPeriod is '课程学时';
comment on column course.AssessMethod is '授课方式';
comment on column course.Courseattribute is '课程类型'; 
comment on column course.WhetherExam is '课程是否考试';
/*
        @author: 刘炳锐
        @date: 2021-09-22
        @function:创建教师表
*/
create table teacher 
(
   tno                nchar(10),
   dno                nchar(4),
   tname              nvarchar2(10)         not null,
   tsex               nchar(1),
   contactnum         nchar(11),
   ptitle             nvarchar2(15),
   tpassword          nvarchar2(16),
   constraint PK_TEACHER primary key (tno),
   foreign key (dno) references department(dno)
)tablespace Educational_information;
-- 给教师表及其字段添加注释
comment on table teacher is '教师信息表';
comment on column teacher.tno is '教师工号，教师表的主键';
comment on column teacher.dno is '教师所属院系，教师表的外键';
comment on column teacher.tname is '教师名称';
comment on column teacher.tsex is '教师性别';
comment on column teacher.contactnum is '教师联系电话';
comment on column teacher.ptitle is '教师职称';
comment on column teacher.tpassword is '教师登录密码';
/*
        @author: 刘炳锐
        @date: 2021-09-22
        @function:创建学生选课表
*/
create table select_course 
(
   select_no          number(8,0),
   sno                nchar(10),
   cno                nchar(10),
	 tno								nchar(10),
   select_date        date default sysdate,
   score              number(3,0) default null,
	 input_time					date default null,
   constraint PK_GRADE primary key (select_no),
   foreign key (sno) references student(sno),
   foreign key (cno) references course(cno),
   foreign key (tno) references teacher(tno)
)tablespace Educational_information;
-- 给学生选课表及其字段添加注释
comment on table select_course is '学生选课信息表';
comment on column select_course.select_no is '学生成绩编号，学生成绩表的主键';
comment on column select_course.sno is '学生学号，学生选课表的外键';
comment on column select_course.cno is '学生所学课程编号，学生选课表的外键';
comment on column select_course.tno is '学生所选课程的授课老师，学生选课表的外键';
comment on column select_course.select_date is '学生选课日期';
comment on column select_course.score is '学生成绩分数';
comment on column select_course.input_time is '学生成绩录入日期';
/*
        @author: 刘炳锐
        @date: 2021-09-22
        @function:创建教室表
*/
create table classroom 
(
   crno               nchar(5),
   crname             nvarchar2(30)         not null,
   position           nvarchar2(100),
   seats_num          NUMBER(3) DEFAULT 60 not null,
   status             NVARCHAR2(10) DEFAULT '空闲' not null,
   DNO                NCHAR(4),
   constraint PK_CLASSROOM primary key (crno),
   foreign key (DNO) references DEPARTMENT(DNO)
)tablespace Educational_information;
-- 给教室表及其字段添加注释
comment on table classroom is '教室信息表';
comment on column classroom.crno is '教室编号，教室表的主键';
comment on column classroom.crname is '教室名称';
comment on column classroom.position is '教室位置';
comment on column classroom.seats_num is '座位数';
comment on column classroom.status is '教室状态';
comment on column classroom.dno is '所属院系，教室表的外键';
/*
        @author: 刘炳锐
        @date: 2021-09-22
        @function:创建评教表
*/
create table evaluation
(
   evno               number(8,0),
   sno                nchar(10),
   tno                nchar(10),
   evdate             date default sysdate,
   ev_leve            nvarchar2(5),
   constraint PK_EVALUATION primary key (evno),
   foreign key (sno) references student(sno),
   foreign key (tno) references teacher(tno)
)tablespace Educational_information;
-- 给评教表及其字段添加注释
comment on table evaluation is '评教信息表';
comment on column evaluation.evno is '评教编号，评教表的主键';
comment on column evaluation.sno is '评教学生学号，评教表的外键';
comment on column evaluation.tno is '评教老师的工号，评教表的外键';
comment on column evaluation.evdate is '评教日期';
comment on column evaluation.ev_leve is '评教等级';
/*
        @author: 刘炳锐
        @date: 2021-09-22
        @function:创建授课表
*/
create table teach 
(
   teano              number(8,0),
   tno                nchar(10),
   cno                nchar(10),
   crno               nchar(5),
   course_time        nvarchar2(40),
   constraint PK_COURSETIME primary key (teano),
   foreign key (tno) references teacher(tno),
   foreign key (cno) references course(cno),
   foreign key (crno) references classroom(crno)
)tablespace Educational_information;
-- 给授课表及其字段添加注释
comment on table teach is '教师授课表';
comment on column teach.teano is '教师授课表编号，教师授课表的主键';
comment on column teach.tno is '课程所教教师编号，教师授课表的外键';
comment on column teach.cno is '课程编号，教师授课表的外键';
comment on column teach.crno is '教室编号，教师授课表的外键';
comment on column teach.course_time is '上课时间';
-- 创建索引
/*
        @author: 刘炳锐
        @date: 2021-09-22
        @function:为专业表创建索引
*/
create index major_fk_index on major(dno asc);
/*
        @author: 刘炳锐
        @date: 2021-09-22
        @function:为班级表创建索引
*/
create index stu_class_fk_index on stu_class(mno asc);
/*
        @author: 刘炳锐
        @date: 2021-09-22
        @function:为学生表创建索引
*/
create index student_fk_class_index on student(classno asc);
create index student_fk_major_index on student(mno asc);
create index student_fk_department_index on student(dno asc); 
/*
        @author: 刘炳锐
        @date: 2021-09-22
        @function:为学生选课表创建索引
*/
create index selectcourse_fk_student_index on select_course(sno asc);
create index selectcourse_fk_course_index on select_course(cno asc);
create index selectcourse_fk_teacher_index on select_course(tno asc);
/*
        @author: 刘炳锐
        @date: 2021-09-22
        @function:为课程表创建索引
*/
create index course_fk_department_index on course(dno asc);
create index course_fk_term_index on course(termno asc); 
/*
        @author: 刘炳锐
        @date: 2021-09-22
        @function:为教室表创建索引
*/
create index classroom_fk_department_index on classroom(dno asc);
/*
        @author: 刘炳锐
        @date: 2021-09-22
        @function:为教师表创建索引
*/
create index teacher_fk_index on teacher(dno asc);
/*
        @author: 刘炳锐
        @date: 2021-09-22
        @function:为评教表创建索引
*/
create index evaluation_fk_student_index on evaluation(sno asc);
create index evaluation_fk_teacher_index on evaluation(tno asc);
/*
        @author: 刘炳锐
        @date: 2021-09-22
        @function:为授课表创建索引
*/
create index teach_fk_teacher_index on teach(tno asc);
create index teach_fk_course_index on teach(cno asc);
create index teach_fk_classroom_index on teach(crno asc);
-- 创建序列
/*
        @author: 刘炳锐
        @date: 2021-09-22
        @function:为选课表创建主键序列
*/
create sequence select_no_sequence increment by 1 start with 1
maxvalue 99999999 order nocache nocycle; 
/*
        @author: 刘炳锐
        @date: 2021-09-22
        @function:为评教表创建主键序列
*/
create sequence evno_sequence increment by 1 start with 1
maxvalue 99999999 order nocache nocycle;
/*
        @author: 刘炳锐
        @date: 2021-09-22
        @function:为授课表创建主键序列
*/
create sequence teano_sequence increment by 1 start with 1
maxvalue 99999999 order nocache nocycle;
-- 创建视图
/*
        @author: 刘炳锐
        @date: 2021-09-22
        @function:创建学生信息视图
*/
create or replace view student_info
(sno,sname,sex,classname,mname,dname,birthday,enro_year,mobile,natnm)
as
select sno,sname,sex,classname,mname,dname,birthday,enro_year,mobile,natnm
from student,major,department,stu_class where student.mno=major.mno and 
student.dno=department.dno and student.classno=stu_class.classno;
/*
        @author: 刘炳锐
        @date: 2021-09-22
        @function:创建教师信息视图
*/
create or replace view teacher_info
(tno,tname,tsex,dname,contactnum,ptitle)
as
select tno,tname,tsex,dname,contactnum,ptitle
from teacher,department where teacher.dno=department.dno;
/*
        @author: 刘炳锐
        @date: 2021-09-22
        @function:创建课程信息视图
*/
create or replace view course_info
(cno,cname,credit,totalperiod,assessmethod,courseattribute,whetherexam,dno,dname,termno,termname,tmname,
tno,tname,crname,position,course_time)
as
select course.cno,cname,credit,totalperiod,assessmethod,courseattribute,whetherexam,department.dno,dname,term.termno,termname,tmname,
teacher.tno,tname,crname,position,course_time from course,classroom,teach,teaching_material,teacher,term,department
where teach.tno=teacher.tno and teach.cno=course.cno and teach.crno=classroom.crno and course.dno=department.dno
and course.termno=term.termno and course.tmno=teaching_material.tmno;
/*
        @author: 刘炳锐
        @date: 2021-09-22
        @function:创建成绩信息视图
*/
create or replace view grade_info
(sno,sname,enro_year,cno,cname,credit,score,tname,termno,termname)
as
select student.sno,sname,enro_year,course.cno,cname,credit,score,tname,term.termno,termname 
from student,select_course,course,teacher,term
where select_course.sno=student.sno and select_course.cno=course.cno
and select_course.tno=teacher.tno and course.termno=term.termno;
/*
        @author: 刘炳锐
        @date: 2021-09-22
        @function:创建评教信息视图
*/
create or replace view evaluation_info
(sno,sname,tno,tname,evdate,ev_leve)
as
select student.sno,sname,teacher.tno,tname,evdate,ev_leve
from student,teacher,evaluation
where evaluation.sno=student.sno and evaluation.tno=teacher.tno;
/*
        @author: 刘炳锐
        @date: 2021-09-22
        @function:创建学生选课信息视图
*/
create or replace view select_course_info
(sno,sname,cno,cname,course_time,credit,totalperiod,assessmethod,courseattribute,
tno,tname,ptitle,termno,termname,crno,crname,position)
as
select student.sno,sname,course.cno,cname,course_time,credit,totalperiod,assessmethod,
courseattribute,teacher.tno,tname,ptitle,term.termno,termname,classroom.crno,crname,position
from student,select_course,course,teacher,teach,classroom,term
where select_course.sno=student.sno and select_course.cno=course.cno and 
select_course.tno=teacher.tno and course.termno=term.termno and teach.crno=classroom.crno
and teach.cno=course.cno and teach.tno=select_course.tno order by student.sno;
-- 给用户授权
/*
        @author: 刘炳锐
        @date: 2021-09-22
        @function:为管理员授权
*/
grant dba to Administrator;
/*
        @author: 刘炳锐
        @date: 2021-09-22
        @function:为教师用户授权
*/
grant connect to Teacher;
grant select on student_info to Teacher;
grant select on teacher_info to Teacher;
grant select on grade_info to Teacher;
grant select on evaluation_info to Teacher;
grant select on course_info to Teacher;
grant select on select_course_info to Student;
grant update(tname,tsex,contactnum,tpassword) on teacher to Teacher;
grant update(score) on select_course to Teacher; 
/*
        @author: 刘炳锐
        @date: 2021-09-22
        @function:为学生用户授权
*/
grant connect to Student;
grant select on student_info to Student;
grant select on teacher_info to Student;
grant select on grade_info to Student;
grant select on course_info to Student;
grant select on select_course_info to Student;
grant update(sname,sex,birthday,mobile,natnm,spassword) on student to Student;
grant insert on evaluation to Student;
grant delete on evaluation to Student;
-- 向表中插入数据
/*
        @author: 刘炳锐
        @date: 2021-09-22
        @function:插入院系信息
*/
insert all 
into department values('ND01','理学院')
into department values('ND02','医学院')
into department values('ND03','食品学院')
into department values('ND04','软件学院')
into department values('ND05','机电工程学院')
into department values('ND06','外国语学院')
into department values('ND07','人文学院')
into department values('ND08','法学院')
into department values('ND09','经济与管理学院')
into department values('ND10','建筑工程学院')
into department values('ND11','体育学院')
into department values('ND12','心理健康教育中心')
into department values('ND13','马克思主义学院')
into department values('ND14','招生与就业工作处（与毕业生就业指导服务中心合署）')
into department values('ND15','公共管理学院')
select * from dual;			
/*
        @author: 刘炳锐
        @date: 2021-09-22
        @function:插入专业信息
*/
insert all 
into major values('ND0101','ND01','数学')
into major values('ND0102','ND01','统计学')
into major values('ND0103','ND01','物理学')
into major values('ND0201','ND02','临床医学')
into major values('ND0202','ND02','口腔医学')
into major values('ND0203','ND02','药学')
into major values('ND0301','ND03','食品科学与工程')
into major values('ND0302','ND03','食品营养与安全')
into major values('ND0303','ND03','食品发酵与生物工程')
into major values('ND0401','ND04','软件工程')
into major values('ND0402','ND04','信息安全')
into major values('ND0403','ND04','计算机二类')
into major values('ND0501','ND05','机械工程')
into major values('ND0502','ND05','能源与动力工程')
into major values('ND0503','ND05','汽车工程')
into major values('ND0601','ND06','英语语言文学')
into major values('ND0602','ND06','亚欧语言文学')
into major values('ND0603','ND06','翻译')
into major values('ND0701','ND07','汉语语言文化')
into major values('ND0702','ND07','古代文学')
into major values('ND0703','ND07','历史学')
into major values('ND0801','ND08','法律学')
into major values('ND0802','ND08','行政管理学')
into major values('ND0803','ND08','哲学')
into major values('ND0901','ND09','经济学')
into major values('ND0902','ND09','金融学')
into major values('ND0903','ND09','工商管理')
into major values('ND1001','ND10','建筑学')
into major values('ND1002','ND10','土木工程')
into major values('ND1003','ND10','水利工程')
select * from dual;		
/*
        @author: 刘炳锐
        @date: 2021-09-22
        @function:插入班级信息
*/
insert all
into stu_class values('ND010101','ND0101','数学01班')
into stu_class values('ND010102','ND0101','数学02班')
into stu_class values('ND010103','ND0101','数学03班')
into stu_class values('ND010201','ND0102','统计学01班')
into stu_class values('ND010202','ND0102','统计学02班')
into stu_class values('ND010203','ND0102','统计学03班')
into stu_class values('ND010301','ND0103','物理学01班')
into stu_class values('ND010302','ND0103','物理学02班')
into stu_class values('ND010303','ND0103','物理学03班')
into stu_class values('ND020101','ND0201','临床医学01班')
into stu_class values('ND020102','ND0201','临床医学02班')
into stu_class values('ND020103','ND0201','临床医学03班')
into stu_class values('ND020201','ND0202','口腔医学01班')
into stu_class values('ND020202','ND0202','口腔医学02班')
into stu_class values('ND020203','ND0202','口腔医学03班')
into stu_class values('ND020301','ND0203','药学01班')
into stu_class values('ND020302','ND0203','药学02班')
into stu_class values('ND020303','ND0203','药学03班')
into stu_class values('ND030101','ND0301','食品科学与工程01班')
into stu_class values('ND030102','ND0301','食品科学与工程02班')
into stu_class values('ND030103','ND0301','食品科学与工程03班')
into stu_class values('ND030201','ND0302','食品营养与安全01班')
into stu_class values('ND030202','ND0302','食品营养与安全02班')
into stu_class values('ND030203','ND0302','食品营养与安全03班')
into stu_class values('ND030301','ND0303','食品发酵与生物工程01班')
into stu_class values('ND030302','ND0303','食品发酵与生物工程02班')
into stu_class values('ND030303','ND0303','食品发酵与生物工程03班')
into stu_class values('ND040101','ND0401','软件工程01班')
into stu_class values('ND040102','ND0401','软件工程02班')
into stu_class values('ND040103','ND0401','软件工程03班')
into stu_class values('ND040201','ND0402','信息安全01班')
into stu_class values('ND040202','ND0402','信息安全02班')
into stu_class values('ND040203','ND0402','信息安全03班')
into stu_class values('ND040301','ND0403','计算机二类01班')
into stu_class values('ND040302','ND0403','计算机二类02班')
into stu_class values('ND040303','ND0403','计算机二类03班')
into stu_class values('ND050101','ND0501','机械工程01班')
into stu_class values('ND050102','ND0501','机械工程02班')
into stu_class values('ND050103','ND0501','机械工程03班')
into stu_class values('ND050201','ND0502','能源与动力工程01班')
into stu_class values('ND050202','ND0502','能源与动力工程02班')
into stu_class values('ND050203','ND0502','能源与动力工程03班')
into stu_class values('ND050301','ND0503','汽车工程01班')
into stu_class values('ND050302','ND0503','汽车工程02班')
into stu_class values('ND050303','ND0503','汽车工程03班')
into stu_class values('ND060101','ND0601','英语语言文学01班')
into stu_class values('ND060102','ND0601','英语语言文学02班')
into stu_class values('ND060103','ND0601','英语语言文学03班')
into stu_class values('ND060201','ND0602','亚欧语言文学01班')
into stu_class values('ND060202','ND0602','亚欧语言文学02班')
into stu_class values('ND060203','ND0602','亚欧语言文学03班')
into stu_class values('ND060301','ND0603','翻译01班')
into stu_class values('ND060302','ND0603','翻译02班')
into stu_class values('ND060303','ND0603','翻译03班')
into stu_class values('ND070101','ND0701','汉语语言文化01班')
into stu_class values('ND070102','ND0701','汉语语言文化02班')
into stu_class values('ND070103','ND0701','汉语语言文化03班')
into stu_class values('ND070201','ND0702','古代文学01班')
into stu_class values('ND070202','ND0702','古代文学02班')
into stu_class values('ND070203','ND0702','古代文学03班')
into stu_class values('ND070301','ND0703','历史学01班')
into stu_class values('ND070302','ND0703','历史学02班')
into stu_class values('ND070303','ND0703','历史学03班')
into stu_class values('ND080101','ND0801','法律学01班')
into stu_class values('ND080102','ND0801','法律学02班')
into stu_class values('ND080103','ND0801','法律学03班')
into stu_class values('ND080201','ND0802','行政管理学01班')
into stu_class values('ND080202','ND0802','行政管理学02班')
into stu_class values('ND080203','ND0802','行政管理学03班')
into stu_class values('ND080301','ND0803','哲学01班')
into stu_class values('ND080302','ND0803','哲学02班')
into stu_class values('ND080303','ND0803','哲学03班')
into stu_class values('ND090101','ND0901','经济学01班')
into stu_class values('ND090102','ND0901','经济学02班')
into stu_class values('ND090103','ND0901','经济学03班')
into stu_class values('ND090201','ND0902','金融学01班')
into stu_class values('ND090202','ND0902','金融学02班')
into stu_class values('ND090203','ND0902','金融学03班')
into stu_class values('ND090301','ND0903','工商管理01班')
into stu_class values('ND090302','ND0903','工商管理02班')
into stu_class values('ND090303','ND0903','工商管理03班')
into stu_class values('ND100101','ND1001','建筑学01班')
into stu_class values('ND100102','ND1001','建筑学02班')
into stu_class values('ND100103','ND1001','建筑学03班')
into stu_class values('ND100201','ND1002','土木工程01班')
into stu_class values('ND100202','ND1002','土木工程02班')
into stu_class values('ND100203','ND1002','土木工程03班')
into stu_class values('ND100301','ND1003','水利工程01班')
into stu_class values('ND100302','ND1003','水利工程02班')
into stu_class values('ND100303','ND1003','水利工程03班')
select * from dual;
/*
        @author: 王俊洪
        @date: 2021-09-22
        @function:插入学生信息
*/
insert all
into student values('8002119001','ND040101','ND0401','ND04','孔媚诚','女',to_date('2001-8-21','YYYY-MM-DD'),to_date('2019','YYYY'),'13205251763','江西省-景德镇市','1234567AB')
into student values('8002119002','ND040101','ND0401','ND04','孙梓旺','女',to_date('2001-8-21','YYYY-MM-DD'),to_date('2019','YYYY'),'15425774087','内蒙古自治区-兴安盟','1234567AB')
into student values('8002119003','ND040101','ND0401','ND04','白子','女',to_date('2001-8-21','YYYY-MM-DD'),to_date('2019','YYYY'),'15547531946','西藏自治区-阿里地区','1234567AB')
into student values('8002119004','ND040101','ND0401','ND04','魏柏蔼','女',to_date('2001-8-21','YYYY-MM-DD'),to_date('2019','YYYY'),'15902079632','江苏省-盐城市','1234567AB')
into student values('8002119005','ND040101','ND0401','ND04','金伟明','女',to_date('2001-8-21','YYYY-MM-DD'),to_date('2019','YYYY'),'15855332324','天津市','1234567AB')
into student values('8002119006','ND040101','ND0401','ND04','姜思','男',to_date('2001-8-21','YYYY-MM-DD'),to_date('2019','YYYY'),'13067011824','青海省-海东市','1234567AB')
into student values('8002119007','ND040101','ND0401','ND04','梁雄','女',to_date('2001-8-21','YYYY-MM-DD'),to_date('2019','YYYY'),'15500803596','新疆维吾尔自治区-伊犁哈萨克自治州','1234567AB')
into student values('8002119008','ND040101','ND0401','ND04','萧健婉','男',to_date('2001-8-21','YYYY-MM-DD'),to_date('2019','YYYY'),'17045144399','青海省-海东市','1234567AB')
into student values('8002119009','ND040101','ND0401','ND04','薛书宇','女',to_date('2001-8-21','YYYY-MM-DD'),to_date('2019','YYYY'),'15451580238','吉林省-吉林市','1234567AB')
into student values('8002119010','ND040101','ND0401','ND04','吴德德','男',to_date('2001-8-21','YYYY-MM-DD'),to_date('2019','YYYY'),'17493720880','湖北省-随州市','1234567AB')
into student values('8002119011','ND040101','ND0401','ND04','赵宇','女',to_date('2001-8-21','YYYY-MM-DD'),to_date('2019','YYYY'),'13468486916','内蒙古自治区-锡林郭勒盟','1234567AB')
into student values('8002119012','ND040101','ND0401','ND04','曾正显','男',to_date('2001-8-21','YYYY-MM-DD'),to_date('2019','YYYY'),'17269401138','陕西省-咸阳市','1234567AB')
into student values('8002119013','ND040101','ND0401','ND04','罗雄德','男',to_date('2001-8-21','YYYY-MM-DD'),to_date('2019','YYYY'),'13342498862','云南省-红河哈尼族彝族自治州','1234567AB')
into student values('8002119014','ND040101','ND0401','ND04','石妯','男',to_date('2001-8-21','YYYY-MM-DD'),to_date('2019','YYYY'),'18986871310','辽宁省-盘锦市','1234567AB')
into student values('8002119015','ND040101','ND0401','ND04','孔睿','男',to_date('2001-8-21','YYYY-MM-DD'),to_date('2019','YYYY'),'18740650263','海南省-三沙市','1234567AB')
into student values('8002119016','ND040101','ND0401','ND04','钟壮','男',to_date('2001-8-21','YYYY-MM-DD'),to_date('2019','YYYY'),'13441822351','青海省-海北藏族自治州','1234567AB')
into student values('8002119017','ND040101','ND0401','ND04','高思','女',to_date('2001-8-21','YYYY-MM-DD'),to_date('2019','YYYY'),'17436004480','吉林省-白城市','1234567AB')
into student values('8002119018','ND040101','ND0401','ND04','郝维轩','男',to_date('2001-8-21','YYYY-MM-DD'),to_date('2019','YYYY'),'15496365206','上海市','1234567AB')
into student values('8002119019','ND040101','ND0401','ND04','东方思焕','男',to_date('2001-8-21','YYYY-MM-DD'),to_date('2019','YYYY'),'18484469353','江西省-九江市','1234567AB')
into student values('8002119020','ND040101','ND0401','ND04','薛杰耀','女',to_date('2001-8-21','YYYY-MM-DD'),to_date('2019','YYYY'),'18475048829','四川省-南充市','1234567AB')
into student values('8002119021','ND040101','ND0401','ND04','孔学','男',to_date('2001-8-21','YYYY-MM-DD'),to_date('2019','YYYY'),'17333977066','宁夏回族自治区-中卫市','1234567AB')
into student values('8002119022','ND040101','ND0401','ND04','曹威耀','男',to_date('2001-8-21','YYYY-MM-DD'),to_date('2019','YYYY'),'15478255690','陕西省-咸阳市','1234567AB')
into student values('8002119023','ND040101','ND0401','ND04','林浩文','男',to_date('2001-8-21','YYYY-MM-DD'),to_date('2019','YYYY'),'17712089890','湖南省-长沙市','1234567AB')
into student values('8002119024','ND040101','ND0401','ND04','方悉','男',to_date('2001-8-21','YYYY-MM-DD'),to_date('2019','YYYY'),'18644794810','辽宁省-本溪市','1234567AB')
into student values('8002119025','ND040101','ND0401','ND04','范学浩','男',to_date('2001-8-21','YYYY-MM-DD'),to_date('2019','YYYY'),'17904164088','贵州省-铜仁市','1234567AB')
into student values('8002119026','ND040101','ND0401','ND04','吕昊','女',to_date('2001-8-21','YYYY-MM-DD'),to_date('2019','YYYY'),'15145305630','福建省-莆田市','1234567AB')
into student values('8002119027','ND040101','ND0401','ND04','赵清','女',to_date('2001-8-21','YYYY-MM-DD'),to_date('2019','YYYY'),'15804186686','内蒙古自治区-通辽市','1234567AB')
into student values('8002119028','ND040101','ND0401','ND04','邓宇','男',to_date('2001-8-21','YYYY-MM-DD'),to_date('2019','YYYY'),'15828140701','天津市','1234567AB')
into student values('8002119029','ND040101','ND0401','ND04','彭清','女',to_date('2001-8-21','YYYY-MM-DD'),to_date('2019','YYYY'),'15136256335','广东省-云浮市','1234567AB')
into student values('8002119030','ND040101','ND0401','ND04','田达子','女',to_date('2001-8-21','YYYY-MM-DD'),to_date('2019','YYYY'),'17350291376','内蒙古自治区-呼和浩特市','1234567AB')
into student values('8002119031','ND040102','ND0401','ND04','赵勤余','女',to_date('1998-4-10','YYYY-MM-DD'),to_date('2019','YYYY'),'18520409085','天津市','1234567AB')
into student values('8002119032','ND040102','ND0401','ND04','萧挺秀','男',to_date('1998-4-10','YYYY-MM-DD'),to_date('2019','YYYY'),'15949580658','广西壮族自治区-南宁市','1234567AB')
into student values('8002119033','ND040102','ND0401','ND04','曹姿','男',to_date('1998-4-10','YYYY-MM-DD'),to_date('2019','YYYY'),'18771187924','吉林省-通化市','1234567AB')
into student values('8002119034','ND040102','ND0401','ND04','姚旺娟','女',to_date('1998-4-10','YYYY-MM-DD'),to_date('2019','YYYY'),'17454232883','宁夏回族自治区-石嘴山市','1234567AB')
into student values('8002119035','ND040102','ND0401','ND04','张俊直','男',to_date('1998-4-10','YYYY-MM-DD'),to_date('2019','YYYY'),'18969703048','新疆维吾尔自治区-自治区直辖县级行政区划','1234567AB')
into student values('8002119036','ND040102','ND0401','ND04','宋迪','男',to_date('1998-4-10','YYYY-MM-DD'),to_date('2019','YYYY'),'13625924462','新疆维吾尔自治区-喀什地区','1234567AB')
into student values('8002119037','ND040102','ND0401','ND04','林锐壮','男',to_date('1998-4-10','YYYY-MM-DD'),to_date('2019','YYYY'),'17395126134','云南省-丽江市','1234567AB')
into student values('8002119038','ND040102','ND0401','ND04','萧维涵','男',to_date('1998-4-10','YYYY-MM-DD'),to_date('2019','YYYY'),'13870111259','广东省-肇庆市','1234567AB')
into student values('8002119039','ND040102','ND0401','ND04','高兴雄','女',to_date('1998-4-10','YYYY-MM-DD'),to_date('2019','YYYY'),'15339840458','河南省-新乡市','1234567AB')
into student values('8002119040','ND040102','ND0401','ND04','梁睿','男',to_date('1998-4-10','YYYY-MM-DD'),to_date('2019','YYYY'),'17562609539','宁夏回族自治区-银川市','1234567AB')
into student values('8002119041','ND040102','ND0401','ND04','吕锐巍','男',to_date('1998-4-10','YYYY-MM-DD'),to_date('2019','YYYY'),'13377359691','浙江省-丽水市','1234567AB')
into student values('8002119042','ND040102','ND0401','ND04','黄轩','女',to_date('1998-4-10','YYYY-MM-DD'),to_date('2019','YYYY'),'17318629942','贵州省-黔南布依族苗族自治州','1234567AB')
into student values('8002119043','ND040102','ND0401','ND04','唐良','男',to_date('1998-4-10','YYYY-MM-DD'),to_date('2019','YYYY'),'17543073629','江苏省-泰州市','1234567AB')
into student values('8002119044','ND040102','ND0401','ND04','方勤浩','女',to_date('1998-4-10','YYYY-MM-DD'),to_date('2019','YYYY'),'13554557359','陕西省-商洛市','1234567AB')
into student values('8002119045','ND040102','ND0401','ND04','魏容','男',to_date('1998-4-10','YYYY-MM-DD'),to_date('2019','YYYY'),'13377268148','江苏省-南通市','1234567AB')
into student values('8002119046','ND040102','ND0401','ND04','陈耀','男',to_date('1998-4-10','YYYY-MM-DD'),to_date('2019','YYYY'),'15843822699','湖北省-黄石市','1234567AB')
into student values('8002119047','ND040102','ND0401','ND04','吴松','男',to_date('1998-4-10','YYYY-MM-DD'),to_date('2019','YYYY'),'17543861580','四川省-资阳市','1234567AB')
into student values('8002119048','ND040102','ND0401','ND04','钟梓子','女',to_date('1998-4-10','YYYY-MM-DD'),to_date('2019','YYYY'),'15200926087','贵州省-黔东南苗族侗族自治州','1234567AB')
into student values('8002119049','ND040102','ND0401','ND04','郑灵','女',to_date('1998-4-10','YYYY-MM-DD'),to_date('2019','YYYY'),'13461701294','内蒙古自治区-包头市','1234567AB')
into student values('8002119050','ND040102','ND0401','ND04','杜娟','男',to_date('1998-4-10','YYYY-MM-DD'),to_date('2019','YYYY'),'18872321799','山东省-泰安市','1234567AB')
into student values('8002119051','ND040102','ND0401','ND04','董伦蔼','男',to_date('1998-4-10','YYYY-MM-DD'),to_date('2019','YYYY'),'15568801589','新疆维吾尔自治区-博尔塔拉蒙古自治州','1234567AB')
into student values('8002119052','ND040102','ND0401','ND04','廖盈欣','男',to_date('1998-4-10','YYYY-MM-DD'),to_date('2019','YYYY'),'17390631524','辽宁省-抚顺市','1234567AB')
into student values('8002119053','ND040102','ND0401','ND04','卢容颖','女',to_date('1998-4-10','YYYY-MM-DD'),to_date('2019','YYYY'),'13381659103','陕西省-榆林市','1234567AB')
into student values('8002119054','ND040102','ND0401','ND04','夏灵显','男',to_date('1998-4-10','YYYY-MM-DD'),to_date('2019','YYYY'),'13693907308','云南省-普洱市','1234567AB')
into student values('8002119055','ND040102','ND0401','ND04','苏昊灵','男',to_date('1998-4-10','YYYY-MM-DD'),to_date('2019','YYYY'),'18756085446','甘肃省-陇南市','1234567AB')
into student values('8002119056','ND040102','ND0401','ND04','任勤','男',to_date('1998-4-10','YYYY-MM-DD'),to_date('2019','YYYY'),'18161020689','海南省-海口市','1234567AB')
into student values('8002119057','ND040102','ND0401','ND04','杜清锐','女',to_date('1998-4-10','YYYY-MM-DD'),to_date('2019','YYYY'),'13299922845','黑龙江省-伊春市','1234567AB')
into student values('8002119058','ND040102','ND0401','ND04','戴丰思','女',to_date('1998-4-10','YYYY-MM-DD'),to_date('2019','YYYY'),'15287904043','黑龙江省-绥化市','1234567AB')
into student values('8002119059','ND040102','ND0401','ND04','黄直柏','女',to_date('1998-4-10','YYYY-MM-DD'),to_date('2019','YYYY'),'17016996798','云南省-保山市','1234567AB')
into student values('8002119060','ND040102','ND0401','ND04','孔析','女',to_date('1998-4-10','YYYY-MM-DD'),to_date('2019','YYYY'),'17009299118','云南省-红河哈尼族彝族自治州','1234567AB')
into student values('8002119061','ND040103','ND0401','ND04','方晰','男',to_date('1999-3-21','YYYY-MM-DD'),to_date('2019','YYYY'),'17619274938','贵州省-毕节市','1234567AB')
into student values('8002119062','ND040103','ND0401','ND04','卢思','男',to_date('1999-3-21','YYYY-MM-DD'),to_date('2019','YYYY'),'18477133321','贵州省-贵阳市','1234567AB')
into student values('8002119063','ND040103','ND0401','ND04','陆明','女',to_date('1999-3-21','YYYY-MM-DD'),to_date('2019','YYYY'),'13344264498','云南省-临沧市','1234567AB')
into student values('8002119064','ND040103','ND0401','ND04','汪正','女',to_date('1999-3-21','YYYY-MM-DD'),to_date('2019','YYYY'),'13255830943','内蒙古自治区-锡林郭勒盟','1234567AB')
into student values('8002119065','ND040103','ND0401','ND04','黄迪仁','男',to_date('1999-3-21','YYYY-MM-DD'),to_date('2019','YYYY'),'18978559118','上海市','1234567AB')
into student values('8002119066','ND040103','ND0401','ND04','傅瑞道','男',to_date('1999-3-21','YYYY-MM-DD'),to_date('2019','YYYY'),'13857103614','海南省-三亚市','1234567AB')
into student values('8002119067','ND040103','ND0401','ND04','钟晰','女',to_date('1999-3-21','YYYY-MM-DD'),to_date('2019','YYYY'),'15285407744','江苏省-盐城市','1234567AB')
into student values('8002119068','ND040103','ND0401','ND04','汪妩杰','女',to_date('1999-3-21','YYYY-MM-DD'),to_date('2019','YYYY'),'18183647943','广东省-云浮市','1234567AB')
into student values('8002119069','ND040103','ND0401','ND04','许锐明','男',to_date('1999-3-21','YYYY-MM-DD'),to_date('2019','YYYY'),'15022973421','青海省-西宁市','1234567AB')
into student values('8002119070','ND040103','ND0401','ND04','金达','女',to_date('1999-3-21','YYYY-MM-DD'),to_date('2019','YYYY'),'18600129971','贵州省-黔西南布依族苗族自治州','1234567AB')
into student values('8002119071','ND040103','ND0401','ND04','钟英','男',to_date('1999-3-21','YYYY-MM-DD'),to_date('2019','YYYY'),'13698249837','青海省-海西蒙古族藏族自治州','1234567AB')
into student values('8002119072','ND040103','ND0401','ND04','杜倩','女',to_date('1999-3-21','YYYY-MM-DD'),to_date('2019','YYYY'),'18515543743','重庆市','1234567AB')
into student values('8002119073','ND040103','ND0401','ND04','董浩','女',to_date('1999-3-21','YYYY-MM-DD'),to_date('2019','YYYY'),'17891436107','海南省-儋州市','1234567AB')
into student values('8002119074','ND040103','ND0401','ND04','高蕊','男',to_date('1999-3-21','YYYY-MM-DD'),to_date('2019','YYYY'),'18783186778','西藏自治区-拉萨市','1234567AB')
into student values('8002119075','ND040103','ND0401','ND04','杨锐学','女',to_date('1999-3-21','YYYY-MM-DD'),to_date('2019','YYYY'),'13167759875','天津市','1234567AB')
into student values('8002119076','ND040103','ND0401','ND04','白思盈','女',to_date('1999-3-21','YYYY-MM-DD'),to_date('2019','YYYY'),'15959246974','青海省-海北藏族自治州','1234567AB')
into student values('8002119077','ND040103','ND0401','ND04','许子','男',to_date('1999-3-21','YYYY-MM-DD'),to_date('2019','YYYY'),'15619146136','上海市','1234567AB')
into student values('8002119078','ND040103','ND0401','ND04','孙勤直','女',to_date('1999-3-21','YYYY-MM-DD'),to_date('2019','YYYY'),'17935370747','湖南省-郴州市','1234567AB')
into student values('8002119079','ND040103','ND0401','ND04','周义杰','女',to_date('1999-3-21','YYYY-MM-DD'),to_date('2019','YYYY'),'15276022199','湖北省-荆州市','1234567AB')
into student values('8002119080','ND040103','ND0401','ND04','罗学','男',to_date('1999-3-21','YYYY-MM-DD'),to_date('2019','YYYY'),'13914566150','安徽省-安庆市','1234567AB')
into student values('8002119081','ND040103','ND0401','ND04','沈清','男',to_date('1999-3-21','YYYY-MM-DD'),to_date('2019','YYYY'),'15045470488','吉林省-白城市','1234567AB')
into student values('8002119082','ND040103','ND0401','ND04','郑轩','女',to_date('1999-3-21','YYYY-MM-DD'),to_date('2019','YYYY'),'13194339732','四川省-攀枝花市','1234567AB')
into student values('8002119083','ND040103','ND0401','ND04','方伦','男',to_date('1999-3-21','YYYY-MM-DD'),to_date('2019','YYYY'),'15261892677','广西壮族自治区-崇左市','1234567AB')
into student values('8002119084','ND040103','ND0401','ND04','丁浩梓','男',to_date('1999-3-21','YYYY-MM-DD'),to_date('2019','YYYY'),'18010961553','天津市','1234567AB')
into student values('8002119085','ND040103','ND0401','ND04','任余','女',to_date('1999-3-21','YYYY-MM-DD'),to_date('2019','YYYY'),'18572935499','黑龙江省-双鸭山市','1234567AB')
into student values('8002119086','ND040103','ND0401','ND04','邓义','男',to_date('1999-3-21','YYYY-MM-DD'),to_date('2019','YYYY'),'17595855633','宁夏回族自治区-固原市','1234567AB')
into student values('8002119087','ND040103','ND0401','ND04','卢清','男',to_date('1999-3-21','YYYY-MM-DD'),to_date('2019','YYYY'),'17290877632','广西壮族自治区-南宁市','1234567AB')
into student values('8002119088','ND040103','ND0401','ND04','吕迪浩','女',to_date('1999-3-21','YYYY-MM-DD'),to_date('2019','YYYY'),'18007975586','甘肃省-金昌市','1234567AB')
into student values('8002119089','ND040103','ND0401','ND04','曹晰','男',to_date('1999-3-21','YYYY-MM-DD'),to_date('2019','YYYY'),'13167944076','四川省-达州市','1234567AB')
into student values('8002119090','ND040103','ND0401','ND04','韩旺','男',to_date('1999-3-21','YYYY-MM-DD'),to_date('2019','YYYY'),'13590555745','新疆维吾尔自治区-阿克苏地区','1234567AB')
into student values('8002119091','ND040201','ND0402','ND04','罗悟','女',to_date('1999-9-25','YYYY-MM-DD'),to_date('2019','YYYY'),'13163239970','福建省-泉州市','1234567AB')
into student values('8002119092','ND040201','ND0402','ND04','范睿盛','男',to_date('1999-9-25','YYYY-MM-DD'),to_date('2019','YYYY'),'18302771496','山西省-晋中市','1234567AB')
into student values('8002119093','ND040201','ND0402','ND04','石直维','男',to_date('1999-9-25','YYYY-MM-DD'),to_date('2019','YYYY'),'13218353147','江苏省-盐城市','1234567AB')
into student values('8002119094','ND040201','ND0402','ND04','东方晓宇','女',to_date('1999-9-25','YYYY-MM-DD'),to_date('2019','YYYY'),'17912684255','江苏省-泰州市','1234567AB')
into student values('8002119095','ND040201','ND0402','ND04','魏诚杰','女',to_date('1999-9-25','YYYY-MM-DD'),to_date('2019','YYYY'),'15265798735','河北省-沧州市','1234567AB')
into student values('8002119096','ND040201','ND0402','ND04','吕明','女',to_date('1999-9-25','YYYY-MM-DD'),to_date('2019','YYYY'),'17983352098','贵州省-黔东南苗族侗族自治州','1234567AB')
into student values('8002119097','ND040201','ND0402','ND04','汪倩媚','女',to_date('1999-9-25','YYYY-MM-DD'),to_date('2019','YYYY'),'15251455895','广东省-中山市','1234567AB')
into student values('8002119098','ND040201','ND0402','ND04','金华妯','男',to_date('1999-9-25','YYYY-MM-DD'),to_date('2019','YYYY'),'18686176286','重庆市','1234567AB')
into student values('8002119099','ND040201','ND0402','ND04','熊柏','男',to_date('1999-9-25','YYYY-MM-DD'),to_date('2019','YYYY'),'18989903543','云南省-曲靖市','1234567AB')
into student values('8002119100','ND040201','ND0402','ND04','吴道','男',to_date('1999-9-25','YYYY-MM-DD'),to_date('2019','YYYY'),'15030840868','广西壮族自治区-河池市','1234567AB')
into student values('8002119101','ND040201','ND0402','ND04','罗媚锐','女',to_date('1999-9-25','YYYY-MM-DD'),to_date('2019','YYYY'),'17668036307','湖南省-衡阳市','1234567AB')
into student values('8002119102','ND040201','ND0402','ND04','吕晓','男',to_date('1999-9-25','YYYY-MM-DD'),to_date('2019','YYYY'),'13272131373','内蒙古自治区-阿拉善盟','1234567AB')
into student values('8002119103','ND040201','ND0402','ND04','熊轩俊','女',to_date('1999-9-25','YYYY-MM-DD'),to_date('2019','YYYY'),'17687313066','河北省-邯郸市','1234567AB')
into student values('8002119104','ND040201','ND0402','ND04','任悉','男',to_date('1999-9-25','YYYY-MM-DD'),to_date('2019','YYYY'),'15074230013','云南省-昭通市','1234567AB')
into student values('8002119105','ND040201','ND0402','ND04','董松壮','男',to_date('1999-9-25','YYYY-MM-DD'),to_date('2019','YYYY'),'13457683637','吉林省-四平市','1234567AB')
into student values('8002119106','ND040201','ND0402','ND04','董哲雨','男',to_date('1999-9-25','YYYY-MM-DD'),to_date('2019','YYYY'),'17725697683','福建省-泉州市','1234567AB')
into student values('8002119107','ND040201','ND0402','ND04','梁耀浩','男',to_date('1999-9-25','YYYY-MM-DD'),to_date('2019','YYYY'),'18533949256','天津市','1234567AB')
into student values('8002119108','ND040201','ND0402','ND04','叶书','男',to_date('1999-9-25','YYYY-MM-DD'),to_date('2019','YYYY'),'15239227671','山西省-运城市','1234567AB')
into student values('8002119109','ND040201','ND0402','ND04','郭义姣','女',to_date('1999-9-25','YYYY-MM-DD'),to_date('2019','YYYY'),'15958993660','辽宁省-辽阳市','1234567AB')
into student values('8002119110','ND040201','ND0402','ND04','谢伟','女',to_date('1999-9-25','YYYY-MM-DD'),to_date('2019','YYYY'),'18966783376','浙江省-丽水市','1234567AB')
into student values('8002119111','ND040201','ND0402','ND04','薛华','女',to_date('1999-9-25','YYYY-MM-DD'),to_date('2019','YYYY'),'18857859868','甘肃省-天水市','1234567AB')
into student values('8002119112','ND040201','ND0402','ND04','任婉清','男',to_date('1999-9-25','YYYY-MM-DD'),to_date('2019','YYYY'),'13825879165','青海省-西宁市','1234567AB')
into student values('8002119113','ND040201','ND0402','ND04','李涵','男',to_date('1999-9-25','YYYY-MM-DD'),to_date('2019','YYYY'),'13475912847','四川省-达州市','1234567AB')
into student values('8002119114','ND040201','ND0402','ND04','宋健挺','男',to_date('1999-9-25','YYYY-MM-DD'),to_date('2019','YYYY'),'15823188566','浙江省-绍兴市','1234567AB')
into student values('8002119115','ND040201','ND0402','ND04','吕涵','男',to_date('1999-9-25','YYYY-MM-DD'),to_date('2019','YYYY'),'13138173639','云南省-德宏傣族景颇族自治州','1234567AB')
into student values('8002119116','ND040201','ND0402','ND04','许婷','男',to_date('1999-9-25','YYYY-MM-DD'),to_date('2019','YYYY'),'15576800045','江西省-鹰潭市','1234567AB')
into student values('8002119117','ND040201','ND0402','ND04','叶子','女',to_date('1999-9-25','YYYY-MM-DD'),to_date('2019','YYYY'),'18256613122','山西省-临汾市','1234567AB')
into student values('8002119118','ND040201','ND0402','ND04','廖兰','男',to_date('1999-9-25','YYYY-MM-DD'),to_date('2019','YYYY'),'15908209967','贵州省-黔西南布依族苗族自治州','1234567AB')
into student values('8002119119','ND040201','ND0402','ND04','朱俊余','女',to_date('1999-9-25','YYYY-MM-DD'),to_date('2019','YYYY'),'18670220525','吉林省-白山市','1234567AB')
into student values('8002119120','ND040201','ND0402','ND04','戴书悦','女',to_date('1999-9-25','YYYY-MM-DD'),to_date('2019','YYYY'),'18670759164','吉林省-长春市','1234567AB')
into student values('8002119121','ND040202','ND0402','ND04','曾勤盛','女',to_date('1999-4-11','YYYY-MM-DD'),to_date('2019','YYYY'),'17368681987','四川省-攀枝花市','1234567AB')
into student values('8002119122','ND040202','ND0402','ND04','何兴','女',to_date('1999-4-11','YYYY-MM-DD'),to_date('2019','YYYY'),'13937873010','湖南省-怀化市','1234567AB')
into student values('8002119123','ND040202','ND0402','ND04','徐英伦','女',to_date('1999-4-11','YYYY-MM-DD'),to_date('2019','YYYY'),'15015729205','西藏自治区-林芝市','1234567AB')
into student values('8002119124','ND040202','ND0402','ND04','范雄','女',to_date('1999-4-11','YYYY-MM-DD'),to_date('2019','YYYY'),'18799357725','上海市','1234567AB')
into student values('8002119125','ND040202','ND0402','ND04','袁焕盛','男',to_date('1999-4-11','YYYY-MM-DD'),to_date('2019','YYYY'),'15887233216','山西省-吕梁市','1234567AB')
into student values('8002119126','ND040202','ND0402','ND04','何浩','女',to_date('1999-4-11','YYYY-MM-DD'),to_date('2019','YYYY'),'13673921423','黑龙江省-绥化市','1234567AB')
into student values('8002119127','ND040202','ND0402','ND04','陆伦','男',to_date('1999-4-11','YYYY-MM-DD'),to_date('2019','YYYY'),'17947814285','云南省-昆明市','1234567AB')
into student values('8002119128','ND040202','ND0402','ND04','邹杰','女',to_date('1999-4-11','YYYY-MM-DD'),to_date('2019','YYYY'),'15115714365','贵州省-贵阳市','1234567AB')
into student values('8002119129','ND040202','ND0402','ND04','杜俊盈','男',to_date('1999-4-11','YYYY-MM-DD'),to_date('2019','YYYY'),'15000979096','青海省-海南藏族自治州','1234567AB')
into student values('8002119130','ND040202','ND0402','ND04','谭浩俊','女',to_date('1999-4-11','YYYY-MM-DD'),to_date('2019','YYYY'),'18886113696','湖北省-随州市','1234567AB')
into student values('8002119131','ND040202','ND0402','ND04','熊明敦','男',to_date('1999-4-11','YYYY-MM-DD'),to_date('2019','YYYY'),'17392813799','河南省-平顶山市','1234567AB')
into student values('8002119132','ND040202','ND0402','ND04','叶仁欣','女',to_date('1999-4-11','YYYY-MM-DD'),to_date('2019','YYYY'),'18771591096','山东省-济宁市','1234567AB')
into student values('8002119133','ND040202','ND0402','ND04','姜婷','女',to_date('1999-4-11','YYYY-MM-DD'),to_date('2019','YYYY'),'15330083863','甘肃省-嘉峪关市','1234567AB')
into student values('8002119134','ND040202','ND0402','ND04','姚妯盈','女',to_date('1999-4-11','YYYY-MM-DD'),to_date('2019','YYYY'),'17231200834','河南省-许昌市','1234567AB')
into student values('8002119135','ND040202','ND0402','ND04','苏轩','女',to_date('1999-4-11','YYYY-MM-DD'),to_date('2019','YYYY'),'18203870090','福建省-莆田市','1234567AB')
into student values('8002119136','ND040202','ND0402','ND04','石悦良','女',to_date('1999-4-11','YYYY-MM-DD'),to_date('2019','YYYY'),'17177152067','陕西省-延安市','1234567AB')
into student values('8002119137','ND040202','ND0402','ND04','徐盛','男',to_date('1999-4-11','YYYY-MM-DD'),to_date('2019','YYYY'),'13762912189','云南省-迪庆藏族自治州','1234567AB')
into student values('8002119138','ND040202','ND0402','ND04','谭悉','男',to_date('1999-4-11','YYYY-MM-DD'),to_date('2019','YYYY'),'15692080973','湖南省-衡阳市','1234567AB')
into student values('8002119139','ND040202','ND0402','ND04','廖伟','男',to_date('1999-4-11','YYYY-MM-DD'),to_date('2019','YYYY'),'15746341365','宁夏回族自治区-中卫市','1234567AB')
into student values('8002119140','ND040202','ND0402','ND04','程盈','男',to_date('1999-4-11','YYYY-MM-DD'),to_date('2019','YYYY'),'18903485882','浙江省-温州市','1234567AB')
into student values('8002119141','ND040202','ND0402','ND04','魏明瑞','女',to_date('1999-4-11','YYYY-MM-DD'),to_date('2019','YYYY'),'15513365044','海南省-海口市','1234567AB')
into student values('8002119142','ND040202','ND0402','ND04','蔡倩','女',to_date('1999-4-11','YYYY-MM-DD'),to_date('2019','YYYY'),'13232923155','内蒙古自治区-乌海市','1234567AB')
into student values('8002119143','ND040202','ND0402','ND04','陆泽','男',to_date('1999-4-11','YYYY-MM-DD'),to_date('2019','YYYY'),'18671773619','广西壮族自治区-桂林市','1234567AB')
into student values('8002119144','ND040202','ND0402','ND04','石巍荣','男',to_date('1999-4-11','YYYY-MM-DD'),to_date('2019','YYYY'),'13192756438','天津市','1234567AB')
into student values('8002119145','ND040202','ND0402','ND04','东方德','女',to_date('1999-4-11','YYYY-MM-DD'),to_date('2019','YYYY'),'15796507383','青海省-海南藏族自治州','1234567AB')
into student values('8002119146','ND040202','ND0402','ND04','萧德','女',to_date('1999-4-11','YYYY-MM-DD'),to_date('2019','YYYY'),'15983782660','浙江省-金华市','1234567AB')
into student values('8002119147','ND040202','ND0402','ND04','董姣','女',to_date('1999-4-11','YYYY-MM-DD'),to_date('2019','YYYY'),'17707860840','西藏自治区-那曲市','1234567AB')
into student values('8002119148','ND040202','ND0402','ND04','梁焕','男',to_date('1999-4-11','YYYY-MM-DD'),to_date('2019','YYYY'),'13166994969','新疆维吾尔自治区-和田地区','1234567AB')
into student values('8002119149','ND040202','ND0402','ND04','胡泽','女',to_date('1999-4-11','YYYY-MM-DD'),to_date('2019','YYYY'),'15902086880','安徽省-宣城市','1234567AB')
into student values('8002119150','ND040202','ND0402','ND04','罗威','女',to_date('1999-4-11','YYYY-MM-DD'),to_date('2019','YYYY'),'13121080276','江西省-鹰潭市','1234567AB')
into student values('8002119151','ND040203','ND0402','ND04','田焕','男',to_date('1998-6-15','YYYY-MM-DD'),to_date('2019','YYYY'),'17596570507','北京市','1234567AB')
into student values('8002119152','ND040203','ND0402','ND04','欧阳直','男',to_date('1998-6-15','YYYY-MM-DD'),to_date('2019','YYYY'),'15146090175','安徽省-安庆市','1234567AB')
into student values('8002119153','ND040203','ND0402','ND04','丁媚浩','男',to_date('1998-6-15','YYYY-MM-DD'),to_date('2019','YYYY'),'15828845555','江西省-景德镇市','1234567AB')
into student values('8002119154','ND040203','ND0402','ND04','方浩','女',to_date('1998-6-15','YYYY-MM-DD'),to_date('2019','YYYY'),'15584465746','海南省-三亚市','1234567AB')
into student values('8002119155','ND040203','ND0402','ND04','石蕊','男',to_date('1998-6-15','YYYY-MM-DD'),to_date('2019','YYYY'),'17100485908','河北省-邢台市','1234567AB')
into student values('8002119156','ND040203','ND0402','ND04','韩娟','男',to_date('1998-6-15','YYYY-MM-DD'),to_date('2019','YYYY'),'17014005961','广西壮族自治区-贺州市','1234567AB')
into student values('8002119157','ND040203','ND0402','ND04','袁慧旺','男',to_date('1998-6-15','YYYY-MM-DD'),to_date('2019','YYYY'),'18986675446','青海省-海北藏族自治州','1234567AB')
into student values('8002119158','ND040203','ND0402','ND04','魏睿','女',to_date('1998-6-15','YYYY-MM-DD'),to_date('2019','YYYY'),'18454649042','湖北省-孝感市','1234567AB')
into student values('8002119159','ND040203','ND0402','ND04','张子','女',to_date('1998-6-15','YYYY-MM-DD'),to_date('2019','YYYY'),'15466441165','天津市','1234567AB')
into student values('8002119160','ND040203','ND0402','ND04','陈松瑞','男',to_date('1998-6-15','YYYY-MM-DD'),to_date('2019','YYYY'),'17234964208','湖北省-咸宁市','1234567AB')
into student values('8002119161','ND040203','ND0402','ND04','叶焕宇','男',to_date('1998-6-15','YYYY-MM-DD'),to_date('2019','YYYY'),'15601738618','河北省-承德市','1234567AB')
into student values('8002119162','ND040203','ND0402','ND04','蔡旺梓','男',to_date('1998-6-15','YYYY-MM-DD'),to_date('2019','YYYY'),'15994370552','广东省-汕尾市','1234567AB')
into student values('8002119163','ND040203','ND0402','ND04','罗哲','男',to_date('1998-6-15','YYYY-MM-DD'),to_date('2019','YYYY'),'18081551207','甘肃省-酒泉市','1234567AB')
into student values('8002119164','ND040203','ND0402','ND04','沈泽迪','女',to_date('1998-6-15','YYYY-MM-DD'),to_date('2019','YYYY'),'18153008309','河北省-廊坊市','1234567AB')
into student values('8002119165','ND040203','ND0402','ND04','马勤','女',to_date('1998-6-15','YYYY-MM-DD'),to_date('2019','YYYY'),'15692931791','吉林省-长春市','1234567AB')
into student values('8002119166','ND040203','ND0402','ND04','沈勤','女',to_date('1998-6-15','YYYY-MM-DD'),to_date('2019','YYYY'),'13262717100','湖南省-湘西土家族苗族自治州','1234567AB')
into student values('8002119167','ND040203','ND0402','ND04','林析良','女',to_date('1998-6-15','YYYY-MM-DD'),to_date('2019','YYYY'),'13275513151','江西省-赣州市','1234567AB')
into student values('8002119168','ND040203','ND0402','ND04','胡山','女',to_date('1998-6-15','YYYY-MM-DD'),to_date('2019','YYYY'),'15334407285','云南省-楚雄彝族自治州','1234567AB')
into student values('8002119169','ND040203','ND0402','ND04','东方泽','女',to_date('1998-6-15','YYYY-MM-DD'),to_date('2019','YYYY'),'15579111523','江苏省-南通市','1234567AB')
into student values('8002119170','ND040203','ND0402','ND04','邹锐盈','男',to_date('1998-6-15','YYYY-MM-DD'),to_date('2019','YYYY'),'17999196616','山西省-大同市','1234567AB')
into student values('8002119171','ND040203','ND0402','ND04','罗梓俊','女',to_date('1998-6-15','YYYY-MM-DD'),to_date('2019','YYYY'),'13340811243','黑龙江省-黑河市','1234567AB')
into student values('8002119172','ND040203','ND0402','ND04','吕晰婉','男',to_date('1998-6-15','YYYY-MM-DD'),to_date('2019','YYYY'),'15397686897','山东省-济南市','1234567AB')
into student values('8002119173','ND040203','ND0402','ND04','罗书悉','女',to_date('1998-6-15','YYYY-MM-DD'),to_date('2019','YYYY'),'17212923591','湖北省-荆门市','1234567AB')
into student values('8002119174','ND040203','ND0402','ND04','陈余梓','男',to_date('1998-6-15','YYYY-MM-DD'),to_date('2019','YYYY'),'13385567742','安徽省-宿州市','1234567AB')
into student values('8002119175','ND040203','ND0402','ND04','马玥娟','男',to_date('1998-6-15','YYYY-MM-DD'),to_date('2019','YYYY'),'17120118979','贵州省-黔西南布依族苗族自治州','1234567AB')
into student values('8002119176','ND040203','ND0402','ND04','胡英俊','男',to_date('1998-6-15','YYYY-MM-DD'),to_date('2019','YYYY'),'17289891289','黑龙江省-伊春市','1234567AB')
into student values('8002119177','ND040203','ND0402','ND04','田诚','女',to_date('1998-6-15','YYYY-MM-DD'),to_date('2019','YYYY'),'18822785313','青海省-海南藏族自治州','1234567AB')
into student values('8002119178','ND040203','ND0402','ND04','任梓','男',to_date('1998-6-15','YYYY-MM-DD'),to_date('2019','YYYY'),'15558013567','贵州省-铜仁市','1234567AB')
into student values('8002119179','ND040203','ND0402','ND04','董梓锐','女',to_date('1998-6-15','YYYY-MM-DD'),to_date('2019','YYYY'),'17930502890','贵州省-黔南布依族苗族自治州','1234567AB')
into student values('8002119180','ND040203','ND0402','ND04','徐昊勤','男',to_date('1998-6-15','YYYY-MM-DD'),to_date('2019','YYYY'),'13682788993','甘肃省-天水市','1234567AB')
into student values('8002119181','ND040301','ND0403','ND04','沈涵','女',to_date('2000-3-4','YYYY-MM-DD'),to_date('2019','YYYY'),'17381828823','北京市','1234567AB')
into student values('8002119182','ND040301','ND0403','ND04','周明英','女',to_date('2000-3-4','YYYY-MM-DD'),to_date('2019','YYYY'),'13529711638','辽宁省-营口市','1234567AB')
into student values('8002119183','ND040301','ND0403','ND04','张勤','女',to_date('2000-3-4','YYYY-MM-DD'),to_date('2019','YYYY'),'18241451680','内蒙古自治区-乌兰察布市','1234567AB')
into student values('8002119184','ND040301','ND0403','ND04','罗雨荣','男',to_date('2000-3-4','YYYY-MM-DD'),to_date('2019','YYYY'),'13540503911','河南省-平顶山市','1234567AB')
into student values('8002119185','ND040301','ND0403','ND04','余轩宇','女',to_date('2000-3-4','YYYY-MM-DD'),to_date('2019','YYYY'),'17436198227','青海省-海东市','1234567AB')
into student values('8002119186','ND040301','ND0403','ND04','阎浩','男',to_date('2000-3-4','YYYY-MM-DD'),to_date('2019','YYYY'),'17003141892','黑龙江省-佳木斯市','1234567AB')
into student values('8002119187','ND040301','ND0403','ND04','阎欣','男',to_date('2000-3-4','YYYY-MM-DD'),to_date('2019','YYYY'),'15605658092','四川省-乐山市','1234567AB')
into student values('8002119188','ND040301','ND0403','ND04','李妯武','女',to_date('2000-3-4','YYYY-MM-DD'),to_date('2019','YYYY'),'13173131351','新疆维吾尔自治区-喀什地区','1234567AB')
into student values('8002119189','ND040301','ND0403','ND04','汪慧','女',to_date('2000-3-4','YYYY-MM-DD'),to_date('2019','YYYY'),'17707458172','福建省-三明市','1234567AB')
into student values('8002119190','ND040301','ND0403','ND04','孙灵','女',to_date('2000-3-4','YYYY-MM-DD'),to_date('2019','YYYY'),'13318380903','四川省-德阳市','1234567AB')
into student values('8002119191','ND040301','ND0403','ND04','韩昌思','女',to_date('2000-3-4','YYYY-MM-DD'),to_date('2019','YYYY'),'18050188797','重庆市','1234567AB')
into student values('8002119192','ND040301','ND0403','ND04','谢晰诚','男',to_date('2000-3-4','YYYY-MM-DD'),to_date('2019','YYYY'),'15122160149','海南省-海口市','1234567AB')
into student values('8002119193','ND040301','ND0403','ND04','董悦','女',to_date('2000-3-4','YYYY-MM-DD'),to_date('2019','YYYY'),'15177786122','山东省-淄博市','1234567AB')
into student values('8002119194','ND040301','ND0403','ND04','薛迪睿','男',to_date('2000-3-4','YYYY-MM-DD'),to_date('2019','YYYY'),'15089344384','河南省-平顶山市','1234567AB')
into student values('8002119195','ND040301','ND0403','ND04','张析','男',to_date('2000-3-4','YYYY-MM-DD'),to_date('2019','YYYY'),'18292505115','江西省-抚州市','1234567AB')
into student values('8002119196','ND040301','ND0403','ND04','李泽浩','男',to_date('2000-3-4','YYYY-MM-DD'),to_date('2019','YYYY'),'17454587502','天津市','1234567AB')
into student values('8002119197','ND040301','ND0403','ND04','黄学婵','女',to_date('2000-3-4','YYYY-MM-DD'),to_date('2019','YYYY'),'13594588002','广西壮族自治区-梧州市','1234567AB')
into student values('8002119198','ND040301','ND0403','ND04','陈梓义','男',to_date('2000-3-4','YYYY-MM-DD'),to_date('2019','YYYY'),'18306291675','河北省-邯郸市','1234567AB')
into student values('8002119199','ND040301','ND0403','ND04','钟妩耀','女',to_date('2000-3-4','YYYY-MM-DD'),to_date('2019','YYYY'),'18528953102','山西省-晋城市','1234567AB')
into student values('8002119200','ND040301','ND0403','ND04','陆山','女',to_date('2000-3-4','YYYY-MM-DD'),to_date('2019','YYYY'),'18617274661','福建省-南平市','1234567AB')
into student values('8002119201','ND040301','ND0403','ND04','阎哲','男',to_date('2000-3-4','YYYY-MM-DD'),to_date('2019','YYYY'),'13176868974','黑龙江省-鸡西市','1234567AB')
into student values('8002119202','ND040301','ND0403','ND04','赵宇正','女',to_date('2000-3-4','YYYY-MM-DD'),to_date('2019','YYYY'),'17317674184','吉林省-白城市','1234567AB')
into student values('8002119203','ND040301','ND0403','ND04','东方达','女',to_date('2000-3-4','YYYY-MM-DD'),to_date('2019','YYYY'),'18133137735','山西省-阳泉市','1234567AB')
into student values('8002119204','ND040301','ND0403','ND04','谢睿蔼','男',to_date('2000-3-4','YYYY-MM-DD'),to_date('2019','YYYY'),'18529965964','天津市','1234567AB')
into student values('8002119205','ND040301','ND0403','ND04','徐宇巍','女',to_date('2000-3-4','YYYY-MM-DD'),to_date('2019','YYYY'),'15425615523','黑龙江省-大庆市','1234567AB')
into student values('8002119206','ND040301','ND0403','ND04','郑仁','女',to_date('2000-3-4','YYYY-MM-DD'),to_date('2019','YYYY'),'18473834192','上海市','1234567AB')
into student values('8002119207','ND040301','ND0403','ND04','田杰','男',to_date('2000-3-4','YYYY-MM-DD'),to_date('2019','YYYY'),'17126182132','甘肃省-定西市','1234567AB')
into student values('8002119208','ND040301','ND0403','ND04','丁松','男',to_date('2000-3-4','YYYY-MM-DD'),to_date('2019','YYYY'),'18907574879','黑龙江省-齐齐哈尔市','1234567AB')
into student values('8002119209','ND040301','ND0403','ND04','王瑞','男',to_date('2000-3-4','YYYY-MM-DD'),to_date('2019','YYYY'),'13737501148','湖北省-随州市','1234567AB')
into student values('8002119210','ND040301','ND0403','ND04','林英','男',to_date('2000-3-4','YYYY-MM-DD'),to_date('2019','YYYY'),'13623672932','甘肃省-甘南藏族自治州','1234567AB')
into student values('8002119211','ND040302','ND0403','ND04','金显','男',to_date('1998-6-28','YYYY-MM-DD'),to_date('2019','YYYY'),'17275391442','湖北省-省直辖县级行政区划','1234567AB')
into student values('8002119212','ND040302','ND0403','ND04','贾达维','男',to_date('1998-6-28','YYYY-MM-DD'),to_date('2019','YYYY'),'17043149351','安徽省-六安市','1234567AB')
into student values('8002119213','ND040302','ND0403','ND04','姜壮','女',to_date('1998-6-28','YYYY-MM-DD'),to_date('2019','YYYY'),'18709126687','新疆维吾尔自治区-克孜勒苏柯尔克孜自治州','1234567AB')
into student values('8002119214','ND040302','ND0403','ND04','彭灵','女',to_date('1998-6-28','YYYY-MM-DD'),to_date('2019','YYYY'),'17074844219','黑龙江省-鸡西市','1234567AB')
into student values('8002119215','ND040302','ND0403','ND04','蒋欣','女',to_date('1998-6-28','YYYY-MM-DD'),to_date('2019','YYYY'),'18602817283','宁夏回族自治区-银川市','1234567AB')
into student values('8002119216','ND040302','ND0403','ND04','张德杰','男',to_date('1998-6-28','YYYY-MM-DD'),to_date('2019','YYYY'),'13816313302','海南省-省直辖县级行政区划','1234567AB')
into student values('8002119217','ND040302','ND0403','ND04','王清慧','女',to_date('1998-6-28','YYYY-MM-DD'),to_date('2019','YYYY'),'18498348312','甘肃省-庆阳市','1234567AB')
into student values('8002119218','ND040302','ND0403','ND04','许石泽','男',to_date('1998-6-28','YYYY-MM-DD'),to_date('2019','YYYY'),'17124097245','青海省-海北藏族自治州','1234567AB')
into student values('8002119219','ND040302','ND0403','ND04','梁挺颖','女',to_date('1998-6-28','YYYY-MM-DD'),to_date('2019','YYYY'),'15497242405','内蒙古自治区-乌海市','1234567AB')
into student values('8002119220','ND040302','ND0403','ND04','刘倩浩','女',to_date('1998-6-28','YYYY-MM-DD'),to_date('2019','YYYY'),'17383179465','海南省-海口市','1234567AB')
into student values('8002119221','ND040302','ND0403','ND04','陈丰敦','男',to_date('1998-6-28','YYYY-MM-DD'),to_date('2019','YYYY'),'13023280359','青海省-海南藏族自治州','1234567AB')
into student values('8002119222','ND040302','ND0403','ND04','卢维维','男',to_date('1998-6-28','YYYY-MM-DD'),to_date('2019','YYYY'),'13850059011','辽宁省-丹东市','1234567AB')
into student values('8002119223','ND040302','ND0403','ND04','卢灵','男',to_date('1998-6-28','YYYY-MM-DD'),to_date('2019','YYYY'),'13096017961','宁夏回族自治区-固原市','1234567AB')
into student values('8002119224','ND040302','ND0403','ND04','吴娟','男',to_date('1998-6-28','YYYY-MM-DD'),to_date('2019','YYYY'),'18883366625','湖南省-岳阳市','1234567AB')
into student values('8002119225','ND040302','ND0403','ND04','汪昊焕','女',to_date('1998-6-28','YYYY-MM-DD'),to_date('2019','YYYY'),'13180282453','天津市','1234567AB')
into student values('8002119226','ND040302','ND0403','ND04','萧悉伦','男',to_date('1998-6-28','YYYY-MM-DD'),to_date('2019','YYYY'),'13548969248','天津市','1234567AB')
into student values('8002119227','ND040302','ND0403','ND04','唐梓子','男',to_date('1998-6-28','YYYY-MM-DD'),to_date('2019','YYYY'),'17193636221','陕西省-商洛市','1234567AB')
into student values('8002119228','ND040302','ND0403','ND04','谭悉蔼','女',to_date('1998-6-28','YYYY-MM-DD'),to_date('2019','YYYY'),'17046049383','上海市','1234567AB')
into student values('8002119229','ND040302','ND0403','ND04','田晰柏','女',to_date('1998-6-28','YYYY-MM-DD'),to_date('2019','YYYY'),'13321111347','宁夏回族自治区-银川市','1234567AB')
into student values('8002119230','ND040302','ND0403','ND04','戴贤灵','男',to_date('1998-6-28','YYYY-MM-DD'),to_date('2019','YYYY'),'18622114485','山西省-晋中市','1234567AB')
into student values('8002119231','ND040302','ND0403','ND04','范思豪','女',to_date('1998-6-28','YYYY-MM-DD'),to_date('2019','YYYY'),'13887314281','辽宁省-盘锦市','1234567AB')
into student values('8002119232','ND040302','ND0403','ND04','谢泽伟','女',to_date('1998-6-28','YYYY-MM-DD'),to_date('2019','YYYY'),'13534505027','湖南省-张家界市','1234567AB')
into student values('8002119233','ND040302','ND0403','ND04','姜涵','男',to_date('1998-6-28','YYYY-MM-DD'),to_date('2019','YYYY'),'15922681674','天津市','1234567AB')
into student values('8002119234','ND040302','ND0403','ND04','谭敦析','男',to_date('1998-6-28','YYYY-MM-DD'),to_date('2019','YYYY'),'18732290118','江苏省-泰州市','1234567AB')
into student values('8002119235','ND040302','ND0403','ND04','郭显旺','男',to_date('1998-6-28','YYYY-MM-DD'),to_date('2019','YYYY'),'13773630229','山西省-太原市','1234567AB')
into student values('8002119236','ND040302','ND0403','ND04','丁娟挺','女',to_date('1998-6-28','YYYY-MM-DD'),to_date('2019','YYYY'),'17979326275','广东省-江门市','1234567AB')
into student values('8002119237','ND040302','ND0403','ND04','赵浩','女',to_date('1998-6-28','YYYY-MM-DD'),to_date('2019','YYYY'),'18736691372','青海省-海北藏族自治州','1234567AB')
into student values('8002119238','ND040302','ND0403','ND04','余颖泽','男',to_date('1998-6-28','YYYY-MM-DD'),to_date('2019','YYYY'),'15261076860','山西省-晋中市','1234567AB')
into student values('8002119239','ND040302','ND0403','ND04','贾思睿','女',to_date('1998-6-28','YYYY-MM-DD'),to_date('2019','YYYY'),'18299521245','西藏自治区-阿里地区','1234567AB')
into student values('8002119240','ND040302','ND0403','ND04','吴松子','女',to_date('1998-6-28','YYYY-MM-DD'),to_date('2019','YYYY'),'18812272645','江西省-赣州市','1234567AB')
into student values('8002119241','ND040303','ND0403','ND04','何慧俊','男',to_date('2001-2-8','YYYY-MM-DD'),to_date('2019','YYYY'),'17598250279','西藏自治区-拉萨市','1234567AB')
into student values('8002119242','ND040303','ND0403','ND04','罗晓','女',to_date('2001-2-8','YYYY-MM-DD'),to_date('2019','YYYY'),'17273310549','广东省-惠州市','1234567AB')
into student values('8002119243','ND040303','ND0403','ND04','曾武健','男',to_date('2001-2-8','YYYY-MM-DD'),to_date('2019','YYYY'),'17201941077','浙江省-嘉兴市','1234567AB')
into student values('8002119244','ND040303','ND0403','ND04','苏析','男',to_date('2001-2-8','YYYY-MM-DD'),to_date('2019','YYYY'),'15087628604','辽宁省-辽阳市','1234567AB')
into student values('8002119245','ND040303','ND0403','ND04','金浩','女',to_date('2001-2-8','YYYY-MM-DD'),to_date('2019','YYYY'),'17202453921','西藏自治区-林芝市','1234567AB')
into student values('8002119246','ND040303','ND0403','ND04','韩泽','女',to_date('2001-2-8','YYYY-MM-DD'),to_date('2019','YYYY'),'15471170424','云南省-德宏傣族景颇族自治州','1234567AB')
into student values('8002119247','ND040303','ND0403','ND04','熊勤','女',to_date('2001-2-8','YYYY-MM-DD'),to_date('2019','YYYY'),'13550114214','上海市','1234567AB')
into student values('8002119248','ND040303','ND0403','ND04','钟松娟','女',to_date('2001-2-8','YYYY-MM-DD'),to_date('2019','YYYY'),'17767596911','湖南省-长沙市','1234567AB')
into student values('8002119249','ND040303','ND0403','ND04','黄慧','男',to_date('2001-2-8','YYYY-MM-DD'),to_date('2019','YYYY'),'17512659754','浙江省-温州市','1234567AB')
into student values('8002119250','ND040303','ND0403','ND04','高娟','女',to_date('2001-2-8','YYYY-MM-DD'),to_date('2019','YYYY'),'15435077691','宁夏回族自治区-银川市','1234567AB')
into student values('8002119251','ND040303','ND0403','ND04','黄华','女',to_date('2001-2-8','YYYY-MM-DD'),to_date('2019','YYYY'),'15932388274','吉林省-松原市','1234567AB')
into student values('8002119252','ND040303','ND0403','ND04','李荣','男',to_date('2001-2-8','YYYY-MM-DD'),to_date('2019','YYYY'),'15026947916','江西省-宜春市','1234567AB')
into student values('8002119253','ND040303','ND0403','ND04','黄晓哲','女',to_date('2001-2-8','YYYY-MM-DD'),to_date('2019','YYYY'),'15254174561','新疆维吾尔自治区-博尔塔拉蒙古自治州','1234567AB')
into student values('8002119254','ND040303','ND0403','ND04','田丰','女',to_date('2001-2-8','YYYY-MM-DD'),to_date('2019','YYYY'),'17800466759','重庆市','1234567AB')
into student values('8002119255','ND040303','ND0403','ND04','董道明','男',to_date('2001-2-8','YYYY-MM-DD'),to_date('2019','YYYY'),'13987124324','上海市','1234567AB')
into student values('8002119256','ND040303','ND0403','ND04','白盛清','男',to_date('2001-2-8','YYYY-MM-DD'),to_date('2019','YYYY'),'13795684538','宁夏回族自治区-中卫市','1234567AB')
into student values('8002119257','ND040303','ND0403','ND04','叶蔼','女',to_date('2001-2-8','YYYY-MM-DD'),to_date('2019','YYYY'),'13351515534','安徽省-亳州市','1234567AB')
into student values('8002119258','ND040303','ND0403','ND04','李宇','女',to_date('2001-2-8','YYYY-MM-DD'),to_date('2019','YYYY'),'18141797202','宁夏回族自治区-固原市','1234567AB')
into student values('8002119259','ND040303','ND0403','ND04','任妍武','女',to_date('2001-2-8','YYYY-MM-DD'),to_date('2019','YYYY'),'15805177187','宁夏回族自治区-中卫市','1234567AB')
into student values('8002119260','ND040303','ND0403','ND04','邓浩睿','男',to_date('2001-2-8','YYYY-MM-DD'),to_date('2019','YYYY'),'15472338977','云南省-曲靖市','1234567AB')
into student values('8002119261','ND040303','ND0403','ND04','孔柏勤','女',to_date('2001-2-8','YYYY-MM-DD'),to_date('2019','YYYY'),'18925103107','福建省-泉州市','1234567AB')
into student values('8002119262','ND040303','ND0403','ND04','魏容','女',to_date('2001-2-8','YYYY-MM-DD'),to_date('2019','YYYY'),'18619017432','山东省-淄博市','1234567AB')
into student values('8002119263','ND040303','ND0403','ND04','钟昊','男',to_date('2001-2-8','YYYY-MM-DD'),to_date('2019','YYYY'),'18739140646','上海市','1234567AB')
into student values('8002119264','ND040303','ND0403','ND04','朱姣','男',to_date('2001-2-8','YYYY-MM-DD'),to_date('2019','YYYY'),'17885430425','云南省-保山市','1234567AB')
into student values('8002119265','ND040303','ND0403','ND04','沈浩','女',to_date('2001-2-8','YYYY-MM-DD'),to_date('2019','YYYY'),'17547728499','广西壮族自治区-贺州市','1234567AB')
into student values('8002119266','ND040303','ND0403','ND04','白子','女',to_date('2001-2-8','YYYY-MM-DD'),to_date('2019','YYYY'),'18342663421','黑龙江省-佳木斯市','1234567AB')
into student values('8002119267','ND040303','ND0403','ND04','高挺','女',to_date('2001-2-8','YYYY-MM-DD'),to_date('2019','YYYY'),'17174100108','浙江省-湖州市','1234567AB')
into student values('8002119268','ND040303','ND0403','ND04','郝旺','男',to_date('2001-2-8','YYYY-MM-DD'),to_date('2019','YYYY'),'18468596127','宁夏回族自治区-银川市','1234567AB')
into student values('8002119269','ND040303','ND0403','ND04','傅灵娟','男',to_date('2001-2-8','YYYY-MM-DD'),to_date('2019','YYYY'),'17314662922','新疆维吾尔自治区-自治区直辖县级行政区划','1234567AB')
into student values('8002119270','ND040303','ND0403','ND04','韩子','男',to_date('2001-2-8','YYYY-MM-DD'),to_date('2019','YYYY'),'17285780703','江苏省-南京市','1234567AB')
select * from dual;
-- select * from student;
-- 插入学期信息
insert all
into term values(1,'小学期')
into term values(2,'上半学期')
into term values(3,'下半学期')
into term values(4,'小学期')
into term values(5,'上半学期')
into term values(6,'下半学期')
into term values(7,'小学期')
into term values(8,'上半学期')
into term values(9,'下半学期')
into term values(10,'小学期')
into term values(11,'上半学期')
into term values(12,'下半学期')
select * from dual;
-- select * from term;
-- 插入教材信息
insert all
into teaching_material values('B0001','高等数学（第七版）上册','同济大学数学系','高等教育出版社')
into teaching_material values('B0002','C语言大学实用教程（第四版）','苏小红、孙志刚','电子工业出版社')
into teaching_material values('B0003','大学进阶英语综合教程2','吴晓真、范烨','上海外语教育出版社')
into teaching_material values('B0004','计算机科学概论（第十二版）','J.GLenn Brookshear','人民邮电出版社')
into teaching_material values('B0005','线性代数','董秋仙、张师贤','上海交通大学出版社')
into teaching_material values('B0006','高等数学（第七版）下册','同济大学数学系','高等教育出版社')
into teaching_material values('B0007','大学物理','骆成洪、刘笑兰','北京邮电大学出版社')
into teaching_material values('B0008','C++语言程序设计（第4版）','郑莉、董渊、何江舟','清华大学出版社')
into teaching_material values('B0009','数字电路（第三版）','贾立新','电子工业出版社')
into teaching_material values('B0010','大学进阶英语综合教程3','吴晓真、范烨','上海外语教育出版社')
into teaching_material values('B0011','数据结构（C语言版）','严蔚敏、吴伟民','清华大学出版社')
into teaching_material values('B0012','深入理解计算机系统（第三版）','兰德尔E.布莱恩特、大卫R.奥哈拉伦','机械工业出版社')
into teaching_material values('B0013','汇编语言（第三版）','王爽','清华大学出版社')
into teaching_material values('B0014','概率论与数理统计（第七版）','乐励华、董秋仙','江西高校出版社')
into teaching_material values('B0015','离散数学','左孝凌、刘永才','上海科学技术文献出版社')
into teaching_material values('B0016','Java2实用教程（第五版）','耿祥义、张跃平','清华大学出版社')
into teaching_material values('B0017','操作系统教程（第六版）','骆斌、葛季栋、费翔林','高等教育出版社')
into teaching_material values('B0018','数据库原理及应用（MySQL版）','李月军、付良廷','清华大学出版社')
into teaching_material values('B0019','计算机网络（第七版）','谢希仁','电子工业出版社')
into teaching_material values('B0020','马克思主义基本原理概论（2018版）','刘建成、郝立新、寇清杰','高等教育出版社')
into teaching_material values('B0021','思想道德修养与法律基础（2018版）','沈壮海、王易','高等教育出版社')
into teaching_material values('B0022','单片机原理与应用','王耀琦','科学出版社')
into teaching_material values('B0023','Java Web 应用开发技术和案例教程（第二版）','张继军、董卫、王婷婷','机械工业出版社')
select * from dual;
/*
        @author: 王诗璐
        @date: 2021-09-22
        @function:插入课程信息
*/
insert all
into course values('J5510N1001','ND01',2,'B0001','高等数学(Ⅰ)上',5,80,'笔试考试','必修','是')
into course values('J8000G0001','ND04',2,'B0002','C语言程序设计',3.5,64,'笔试考试','必修','是')
into course values('T5130F1001','ND06',2,'B0003','大学英语（1）',3,48,'笔试考试','必修','是')
into course values('T8000C0001','ND04',2,'B0004','计算机概论',2.5,56,'笔试考试','必修','是')
into course values('J5510N0006','ND01',2,'B0005','线性代数',2,32,'笔试考试','选修','是')
into course values('J5510N2001','ND01',2,'B0006','高等数学(Ⅰ)下',5,80,'笔试考试','选修','是')
into course values('J5520N1002','ND01',2,'B0007','大学物理（Ⅱ）',4,64,'笔试考试','选修','是')
into course values('J8000G0002','ND04',2,'B0008','C++程序设计',3.5,64,'笔试考试','选修','是')
into course values('J8000G0006','ND04',3,'B0009','电子线路与数字逻辑',3.5,64,'笔试考试','必修','是')
into course values('T5130F2001','ND06',3,'B0010','大学英语（2）',3,48,'笔试考试','必修','是')
into course values('J8000G0003','ND04',2,'B0011','数据结构与算法',3.5,64,'笔试考试','必修','是')
into course values('J8000G0005','ND04',5,'B0012','计算机组成原理',3.5,64,'笔试考试','必修','是')
into course values('J8000G0012','ND04',5,'B0013','汇编语言程序设计',1.5,32,'笔试考试','必修','是')
into course values('J8030G0001','ND04',5,'B0014','概率论与数理统计（ⅠⅠ）',2,32,'笔试考试','必修','是')
into course values('J8030G0002','ND04',5,'B0015','离散数学',4,64,'笔试考试','必修','是')
into course values('Z8000B0001','ND04',5,'B0016','Java程序设计',3,64,'笔试考试','必修','是')
into course values('J8000G0004','ND04',6,'B0017','操作系统',3.5,64,'笔试考试','必修','是')
into course values('J8000G0007','ND04',6,'B0018','数据库原理',3.5,64,'笔试考试','必修','是')
into course values('J8000G0008','ND04',6,'B0019','计算机通信与网络',3.5,64,'笔试考试','必修','是')
into course values('T7210P0002','ND13',6,'B0020','马克思主义基本原理',3,48,'笔试考试','必修','是')
into course values('T7210P0003','ND13',6,'B0021','思想道德修养与法律基础',3,48,'笔试考试','必修','是')
into course values('Z8020B0010','ND04',6,'B0022','单片机原理与接口技术',3,64,'笔试考试','必修','是')
into course values('Z802SB0010','ND04',6,'B0023','Web应用技术（JavaEE）',2,64,'笔试考试','必修','是')
select * from dual;
/*
        @author: 王俊洪
        @date: 2021-09-22
        @function:插入教师信息
*/
INSERT ALL
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND01TNO001','ND01','东方蔼耀','女','15252112924','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND01TNO002','ND01','袁宇','女','15921879629','讲师','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND01TNO003','ND01','杨敦妩','男','17320532221','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND01TNO004','ND01','夏盛俊','女','15599910582','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND01TNO005','ND01','范婷瑞','女','18529354291','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND01TNO006','ND01','薛兴','男','18604799155','讲师','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND01TNO007','ND01','贾倩','男','18833837867','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND01TNO008','ND01','方文','女','18281082403','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND01TNO009','ND01','潘德兴','男','13242157852','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND01TNO010','ND01','唐敦','男','15725121691','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND01TNO011','ND01','钟颖','女','13565038339','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND01TNO012','ND01','苏梓正','女','17725838203','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND01TNO013','ND01','林婉','男','18211749451','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND01TNO014','ND01','马英','女','17782062831','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND01TNO015','ND01','任昌颖','男','13493534810','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND01TNO016','ND01','余晰子','女','17467797287','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND01TNO017','ND01','谭浩','男','13699214003','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND01TNO018','ND01','孙伦','男','18210798043','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND01TNO019','ND01','姚雄析','女','15041541449','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND01TNO020','ND01','薛轩','女','15301157455','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND01TNO021','ND01','胡婉浩','男','17484556547','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND01TNO022','ND01','夏英','男','17214655440','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND01TNO023','ND01','欧阳兰梓','女','17537969042','讲师','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND01TNO024','ND01','东方华','女','13136778902','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND01TNO025','ND01','薛梓昌','女','18772621610','讲师','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND01TNO026','ND01','周子轩','男','17721813905','讲师','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND01TNO027','ND01','程华旺','女','15336365103','讲师','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND01TNO028','ND01','东方婷','男','13685007185','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND01TNO029','ND01','叶蔼','男','17205961630','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND01TNO030','ND01','薛倩宇','男','15046489813','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND02TNO001','ND02','夏挺','男','17341112966','讲师','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND02TNO002','ND02','薛婵梓','男','18631450165','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND02TNO003','ND02','韩梓','男','15962420422','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND02TNO004','ND02','周轩睿','男','15892063737','讲师','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND02TNO005','ND02','丁健晰','女','13452871534','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND02TNO006','ND02','丁浩','男','18310579939','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND02TNO007','ND02','郑灵晰','男','18450522554','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND02TNO008','ND02','彭敦仁','女','13190532804','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND02TNO009','ND02','蔡瑞','女','13610515420','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND02TNO010','ND02','林武蕊','女','13623090048','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND02TNO011','ND02','沈宇','男','18378661954','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND02TNO012','ND02','陆荣','女','18789340745','讲师','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND02TNO013','ND02','林华锐','女','18719648055','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND02TNO014','ND02','马学敦','女','17135701190','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND02TNO015','ND02','李媚思','男','13970025049','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND02TNO016','ND02','钟维','男','13353167549','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND02TNO017','ND02','傅俊','男','15207411168','讲师','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND02TNO018','ND02','苏婷挺','女','18762476365','讲师','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND02TNO019','ND02','姚良媚','男','18188864565','讲师','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND02TNO020','ND02','魏盈妩','男','13540091644','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND02TNO021','ND02','戴健石','男','17921825059','讲师','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND02TNO022','ND02','夏博','男','15613064521','讲师','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND02TNO023','ND02','石泽昌','女','17070822366','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND02TNO024','ND02','方蔼','男','13628347794','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND02TNO025','ND02','沈容','男','13516781380','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND02TNO026','ND02','张德旺','女','15981609923','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND02TNO027','ND02','孔文','女','17405016633','讲师','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND02TNO028','ND02','郑子','男','17509036263','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND02TNO029','ND02','余勤妍','女','17563985695','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND02TNO030','ND02','夏悟壮','男','18035215248','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND03TNO001','ND03','石宇豪','女','17875730730','讲师','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND03TNO002','ND03','马焕昊','女','13932845716','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND03TNO003','ND03','程娟荣','男','15314933243','讲师','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND03TNO004','ND03','卢婉妯','女','18214778475','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND03TNO005','ND03','蔡轩旺','男','15788470152','讲师','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND03TNO006','ND03','沈昌蕊','女','17559745981','讲师','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND03TNO007','ND03','蒋兰清','女','17383622609','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND03TNO008','ND03','孔婵','男','15816791967','讲师','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND03TNO009','ND03','邹俊英','女','15851299500','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND03TNO010','ND03','吕正梓','女','17230974872','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND03TNO011','ND03','林仁姣','女','17267849573','讲师','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND03TNO012','ND03','任石悟','男','15075544085','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND03TNO013','ND03','郭英文','女','18070525356','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND03TNO014','ND03','傅荣','女','18033731735','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND03TNO015','ND03','唐达','男','13907975835','讲师','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND03TNO016','ND03','范柏英','男','18843180871','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND03TNO017','ND03','潘维兴','女','15701524378','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND03TNO018','ND03','叶涵德','男','17114457932','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND03TNO019','ND03','陆妩','女','17130337455','讲师','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND03TNO020','ND03','马盈盛','女','15351384618','讲师','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND03TNO021','ND03','王文诚','男','15006616216','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND03TNO022','ND03','贾荣豪','女','18738696545','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND03TNO023','ND03','傅妯','男','13055349570','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND03TNO024','ND03','戴昊','男','13794857580','讲师','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND03TNO025','ND03','袁慧','女','18494627039','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND03TNO026','ND03','金华','女','15980663911','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND03TNO027','ND03','罗德','男','18312862777','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND03TNO028','ND03','杨明轩','女','15306615487','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND03TNO029','ND03','胡秀轩','女','18790990119','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND03TNO030','ND03','阎良丰','男','17863136278','讲师','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND04TNO001','ND04','刘娟书','女','18215568903','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND04TNO002','ND04','郭杰浩','女','13081349542','讲师','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND04TNO003','ND04','汪俊','男','17102549769','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND04TNO004','ND04','廖姣昌','女','13106180251','讲师','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND04TNO005','ND04','陈宇明','女','18013460762','讲师','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND04TNO006','ND04','曹子','女','15413219073','讲师','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND04TNO007','ND04','胡伦','女','13799914748','讲师','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND04TNO008','ND04','曹轩清','男','15517913344','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND04TNO009','ND04','徐诚婷','女','17269980129','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND04TNO010','ND04','朱兴豪','男','13294801900','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND04TNO011','ND04','杨贤','男','17720546742','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND04TNO012','ND04','任轩妯','男','15584607533','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND04TNO013','ND04','姜婉','女','15625007477','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND04TNO014','ND04','袁壮勤','男','18526003311','讲师','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND04TNO015','ND04','陆壮悟','男','18769461508','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND04TNO016','ND04','何锐','男','18155544826','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND04TNO017','ND04','袁秀婉','女','17321480256','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND04TNO018','ND04','萧灵','女','13980790627','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND04TNO019','ND04','马挺思','男','15081922695','讲师','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND04TNO020','ND04','卢兴','男','18455294353','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND04TNO021','ND04','叶昊直','男','18276287214','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND04TNO022','ND04','余容雨','男','15990997950','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND04TNO023','ND04','王妯','男','18779399332','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND04TNO024','ND04','吕思武','男','13697372193','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND04TNO025','ND04','丁文','男','13073949915','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND04TNO026','ND04','许晓书','男','13433783619','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND04TNO027','ND04','蔡容','男','18400440630','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND04TNO028','ND04','潘锐俊','女','18927795197','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND04TNO029','ND04','陈挺义','男','18122845697','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND04TNO030','ND04','马婵','男','13346890453','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND05TNO001','ND05','郝盈','男','15670726011','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND05TNO002','ND05','姜直德','男','13745613264','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND05TNO003','ND05','何威德','男','13726093295','讲师','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND05TNO004','ND05','赵清','男','17898054418','讲师','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND05TNO005','ND05','姜昊','男','13872631982','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND05TNO006','ND05','余灵博','男','15789895423','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND05TNO007','ND05','陈浩','男','17248877861','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND05TNO008','ND05','彭焕','男','15249480812','讲师','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND05TNO009','ND05','薛锐伦','男','18857356489','讲师','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND05TNO010','ND05','邹华俊','女','15754403650','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND05TNO011','ND05','廖瑞宇','女','17223545955','讲师','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND05TNO012','ND05','曹博巍','男','13110637690','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND05TNO013','ND05','蒋俊浩','女','17737007395','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND05TNO014','ND05','白子','男','17784103249','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND05TNO015','ND05','宋书敦','男','17498290977','讲师','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND05TNO016','ND05','魏耀宇','男','18242225786','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND05TNO017','ND05','梁豪焕','女','18590371380','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND05TNO018','ND05','范析姣','男','15091685455','讲师','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND05TNO019','ND05','孔明轩','女','18551521099','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND05TNO020','ND05','黄义','女','15043162377','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND05TNO021','ND05','程欣豪','女','17575527396','讲师','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND05TNO022','ND05','袁盈','女','18280929594','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND05TNO023','ND05','阎书','男','18338846091','讲师','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND05TNO024','ND05','何松晓','男','13459142306','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND05TNO025','ND05','丁丰睿','男','15775808063','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND05TNO026','ND05','方颖','女','18321414171','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND05TNO027','ND05','石俊','男','15209012166','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND05TNO028','ND05','吴伟','女','15478233438','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND05TNO029','ND05','任直','男','15609807569','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND05TNO030','ND05','许伦伟','女','15273571362','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND06TNO001','ND06','邹思子','男','13401973205','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND06TNO002','ND06','萧晓盛','女','15336698296','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND06TNO003','ND06','周豪','女','15822347063','讲师','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND06TNO004','ND06','汪妯婷','男','18530783848','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND06TNO005','ND06','周仁','女','13134435671','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND06TNO006','ND06','何义诚','男','15670137421','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND06TNO007','ND06','叶轩','男','15006174722','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND06TNO008','ND06','孙析宇','女','17299900839','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND06TNO009','ND06','袁锐英','男','13635354496','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND06TNO010','ND06','马敦','男','15746957710','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND06TNO011','ND06','董姿','男','13725606523','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND06TNO012','ND06','曾良蔼','女','13429609479','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND06TNO013','ND06','程轩豪','女','18574223747','讲师','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND06TNO014','ND06','宋颖余','男','15845630660','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND06TNO015','ND06','林丰轩','女','18079902919','讲师','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND06TNO016','ND06','袁颖焕','女','18935600986','讲师','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND06TNO017','ND06','马伦','男','13208872441','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND06TNO018','ND06','周灵兴','女','15489607850','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND06TNO019','ND06','张松','男','15490848282','讲师','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND06TNO020','ND06','姚威','女','13971672003','讲师','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND06TNO021','ND06','阎睿思','女','15617715312','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND06TNO022','ND06','金婷','男','17827945104','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND06TNO023','ND06','田盈','男','15622946373','讲师','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND06TNO024','ND06','田柏倩','男','17768216629','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND06TNO025','ND06','曾石','女','13424606402','讲师','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND06TNO026','ND06','丁梓','男','15373232961','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND06TNO027','ND06','卢正维','女','15732640336','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND06TNO028','ND06','许婵','女','18852802264','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND06TNO029','ND06','徐荣','女','15849870880','讲师','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND06TNO030','ND06','孔巍','男','18502899261','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND07TNO001','ND07','曾勤容','女','15650036497','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND07TNO002','ND07','阎仁','女','13709949954','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND07TNO003','ND07','廖娟','女','15666942707','讲师','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND07TNO004','ND07','邹明','女','13924474154','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND07TNO005','ND07','田兴','女','13668755684','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND07TNO006','ND07','陆俊','女','13680455124','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND07TNO007','ND07','高姿维','男','18430915875','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND07TNO008','ND07','梁瑞','男','15277689802','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND07TNO009','ND07','董泽华','女','15717613064','讲师','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND07TNO010','ND07','夏容妍','男','17462381041','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND07TNO011','ND07','高松','女','15306733318','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND07TNO012','ND07','徐维杰','男','18672650767','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND07TNO013','ND07','阎颖学','女','18023090345','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND07TNO014','ND07','王学','男','17760699560','讲师','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND07TNO015','ND07','何妩','男','17767252444','讲师','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND07TNO016','ND07','王妩','男','18669252108','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND07TNO017','ND07','曾雨','女','18192090449','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND07TNO018','ND07','陆书','女','17933722989','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND07TNO019','ND07','钟丰','男','17100446011','讲师','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND07TNO020','ND07','何良巍','男','13940608095','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND07TNO021','ND07','阎仁','女','18672639082','讲师','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND07TNO022','ND07','薛俊涵','男','15000550643','讲师','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND07TNO023','ND07','范慧','女','13760652395','讲师','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND07TNO024','ND07','阎勤清','女','15862906332','讲师','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND07TNO025','ND07','周明子','女','17731975848','讲师','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND07TNO026','ND07','傅媚','女','17922754052','讲师','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND07TNO027','ND07','薛宇','女','13910623455','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND07TNO028','ND07','姚浩','女','18603560346','讲师','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND07TNO029','ND07','沈思婵','男','18595230603','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND07TNO030','ND07','梁兰','女','13733043365','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND08TNO001','ND08','吕学','女','15616234671','讲师','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND08TNO002','ND08','周思子','男','15825967662','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND08TNO003','ND08','谢伦锐','男','15203747582','讲师','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND08TNO004','ND08','白石浩','女','13873296960','讲师','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND08TNO005','ND08','陈清','女','17090712655','讲师','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND08TNO006','ND08','夏敦俊','男','15777048464','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND08TNO007','ND08','陈清','女','17942756987','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND08TNO008','ND08','卢俊显','女','17345237073','讲师','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND08TNO009','ND08','钟轩','男','17814050712','讲师','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND08TNO010','ND08','罗敦','女','13687977605','讲师','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND08TNO011','ND08','杨宇明','女','17783461597','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND08TNO012','ND08','吴良蔼','男','17847193969','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND08TNO013','ND08','朱仁','男','18619234455','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND08TNO014','ND08','戴悟婷','男','15856072814','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND08TNO015','ND08','汪学','男','18889454865','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND08TNO016','ND08','何威','女','13082235163','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND08TNO017','ND08','马悦文','女','17176564344','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND08TNO018','ND08','苏达','男','13202596739','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND08TNO019','ND08','熊达妩','男','17860891570','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND08TNO020','ND08','石瑞勤','男','13401755405','讲师','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND08TNO021','ND08','蔡达娟','男','18508457701','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND08TNO022','ND08','姚泽泽','女','17821986309','讲师','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND08TNO023','ND08','许武晓','男','17763850004','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND08TNO024','ND08','廖挺','女','18497157901','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND08TNO025','ND08','孙雨','男','15673111505','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND08TNO026','ND08','高慧','男','18863550471','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND08TNO027','ND08','陈雄丰','女','17122837172','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND08TNO028','ND08','范学兴','女','15861590763','讲师','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND08TNO029','ND08','金灵秀','男','15526560066','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND08TNO030','ND08','廖柏','女','17264094884','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND09TNO001','ND09','何英睿','男','17751841370','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND09TNO002','ND09','曹豪','男','18612419417','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND09TNO003','ND09','董宇仁','男','17088441815','讲师','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND09TNO004','ND09','曾诚','女','15938576196','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND09TNO005','ND09','东方豪德','男','15480475602','讲师','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND09TNO006','ND09','程思','男','17061845903','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND09TNO007','ND09','梁宇','男','18083521888','讲师','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND09TNO008','ND09','罗焕妩','女','18863134828','讲师','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND09TNO009','ND09','罗雄','女','18503910128','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND09TNO010','ND09','贾轩文','男','13753475307','讲师','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND09TNO011','ND09','蔡析','女','17486205581','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND09TNO012','ND09','胡娟兴','男','15047174365','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND09TNO013','ND09','谭媚','男','18930598722','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND09TNO014','ND09','任睿','男','18630492630','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND09TNO015','ND09','陈旺哲','女','17880757255','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND09TNO016','ND09','蒋瑞英','男','18058343321','讲师','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND09TNO017','ND09','曾婷道','女','13234039486','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND09TNO018','ND09','刘荣文','男','18875536626','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND09TNO019','ND09','曹浩','男','17793682347','讲师','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND09TNO020','ND09','姚姿婷','男','18419931402','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND09TNO021','ND09','高锐婉','女','13438391655','讲师','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND09TNO022','ND09','郝轩贤','女','17515388265','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND09TNO023','ND09','彭正昌','女','18773714797','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND09TNO024','ND09','廖梓梓','女','17253983001','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND09TNO025','ND09','范焕宇','女','17964019018','讲师','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND09TNO026','ND09','唐泽瑞','男','18961075169','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND09TNO027','ND09','熊荣正','男','18783887725','讲师','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND09TNO028','ND09','汪媚','女','15648487907','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND09TNO029','ND09','黄睿睿','男','17061682481','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND09TNO030','ND09','汪昊明','女','18555952734','讲师','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND10TNO001','ND10','彭睿英','女','15028456610','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND10TNO002','ND10','郑清','女','17042874397','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND10TNO003','ND10','叶挺','女','13926226223','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND10TNO004','ND10','潘浩','女','18903163506','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND10TNO005','ND10','戴析','男','18199237413','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND10TNO006','ND10','吴雨','男','13389753164','讲师','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND10TNO007','ND10','姜勤','男','17213250810','讲师','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND10TNO008','ND10','周良','女','15861438986','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND10TNO009','ND10','蒋宇耀','男','18176590965','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND10TNO010','ND10','徐松','男','17322039814','讲师','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND10TNO011','ND10','宋宇悟','女','15140920116','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND10TNO012','ND10','金俊','男','17073649051','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND10TNO013','ND10','林晓维','女','18948108043','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND10TNO014','ND10','刘悉','男','13875865765','讲师','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND10TNO015','ND10','宋蕊','男','15097824505','讲师','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND10TNO016','ND10','罗武','男','13335487087','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND10TNO017','ND10','石锐','女','13176664109','讲师','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND10TNO018','ND10','阎显哲','女','18478562246','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND10TNO019','ND10','郝山泽','女','18398877566','讲师','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND10TNO020','ND10','汪灵石','女','17631173848','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND10TNO021','ND10','贾正维','女','17573899463','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND10TNO022','ND10','徐涵','男','15000752773','讲师','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND10TNO023','ND10','宋姿昊','女','18032776445','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND10TNO024','ND10','郑文','女','17867099628','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND10TNO025','ND10','薛贤','男','18090511016','讲师','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND10TNO026','ND10','欧阳娟华','男','13052671433','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND10TNO027','ND10','丁瑞','男','17059687976','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND10TNO028','ND10','高哲','男','13112305235','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND10TNO029','ND10','谢悉清','男','15617534188','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND10TNO030','ND10','何妯','男','15343123181','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND11TNO001','ND11','曾悟','女','15212833128','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND11TNO002','ND11','叶余','女','13962744660','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND11TNO003','ND11','吴余正','女','17351268417','讲师','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND11TNO004','ND11','罗威正','男','13281965689','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND11TNO005','ND11','朱迪','男','18703881817','讲师','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND11TNO006','ND11','东方梓','女','18748294614','讲师','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND11TNO007','ND11','赵杰','男','17948158788','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND11TNO008','ND11','金道昊','男','18246172565','讲师','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND11TNO009','ND11','赵瑞华','女','15856677884','讲师','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND11TNO010','ND11','董轩','男','15922433794','讲师','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND11TNO011','ND11','林昌','女','18119721271','讲师','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND11TNO012','ND11','郑泽','女','13232806863','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND11TNO013','ND11','董健健','男','13439169210','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND11TNO014','ND11','罗妍慧','女','17917663755','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND11TNO015','ND11','陆思媚','女','13345378162','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND11TNO016','ND11','贾健丰','男','13308218997','讲师','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND11TNO017','ND11','袁妯英','女','15455485919','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND11TNO018','ND11','余良俊','男','18834772666','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND11TNO019','ND11','白浩慧','男','18345747005','讲师','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND11TNO020','ND11','孔直晓','男','17874382017','讲师','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND11TNO021','ND11','陆兴','男','17500963595','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND11TNO022','ND11','赵博哲','男','15584185201','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND11TNO023','ND11','王学荣','女','18674646511','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND11TNO024','ND11','罗柏兴','男','15096869667','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND11TNO025','ND11','曾瑞妯','女','17435641421','讲师','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND11TNO026','ND11','石瑞容','男','15255710000','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND11TNO027','ND11','东方哲宇','男','17938354458','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND11TNO028','ND11','徐秀','男','17096989737','讲师','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND11TNO029','ND11','张浩焕','女','17204788606','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND11TNO030','ND11','许博浩','男','15116071428','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND12TNO001','ND12','陈文巍','女','13943163271','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND12TNO002','ND12','吕英','男','17485697569','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND12TNO003','ND12','廖欣豪','男','15758739075','讲师','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND12TNO004','ND12','廖敦','男','15860143948','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND12TNO005','ND12','罗武盈','女','17158740365','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND12TNO006','ND12','王学','女','13127877010','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND12TNO007','ND12','黄颖','男','17825255074','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND12TNO008','ND12','周明','女','18429064008','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND12TNO009','ND12','孙伦','女','18952531885','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND12TNO010','ND12','郑瑞','男','15028180549','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND12TNO011','ND12','邹贤兴','男','18418156438','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND12TNO012','ND12','蔡明姣','男','18982940305','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND12TNO013','ND12','袁贤旺','男','17678171898','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND12TNO014','ND12','范良','男','15270727921','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND12TNO015','ND12','苏石姿','女','15427443587','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND12TNO016','ND12','高贤德','女','18171731364','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND12TNO017','ND12','白娟石','女','17380549411','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND12TNO018','ND12','熊悉梓','男','18321811371','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND12TNO019','ND12','余显','女','17012709878','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND12TNO020','ND12','蒋盛焕','女','18507335453','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND12TNO021','ND12','傅书正','女','18585773692','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND12TNO022','ND12','何颖慧','男','13835578013','讲师','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND12TNO023','ND12','傅浩','男','15616041499','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND12TNO024','ND12','吴浩','男','18944246294','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND12TNO025','ND12','吴瑞','女','15282125968','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND12TNO026','ND12','东方泽','男','17395002238','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND12TNO027','ND12','钟轩兴','女','18488257099','讲师','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND12TNO028','ND12','唐伟','女','17188402801','讲师','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND12TNO029','ND12','刘慧梓','女','17766715437','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND12TNO030','ND12','廖豪俊','男','18956029948','讲师','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND13TNO001','ND13','郑轩正','男','18833080401','讲师','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND13TNO002','ND13','王石','女','13392440193','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND13TNO003','ND13','吴兴仁','男','18933423087','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND13TNO004','ND13','张颖宇','男','13664807143','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND13TNO005','ND13','魏蕊思','女','17276141528','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND13TNO006','ND13','任析','女','15240041285','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND13TNO007','ND13','东方勤','女','15367132157','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND13TNO008','ND13','戴盛','男','18966976712','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND13TNO009','ND13','郝德','女','15033490863','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND13TNO010','ND13','吴灵','女','13685298377','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND13TNO011','ND13','方娟','女','15128459592','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND13TNO012','ND13','马武','女','18675436419','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND13TNO013','ND13','朱盈','男','17635910947','讲师','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND13TNO014','ND13','黄学妩','男','17664471997','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND13TNO015','ND13','程焕姣','女','18363676869','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND13TNO016','ND13','熊道妯','男','15905744111','讲师','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND13TNO017','ND13','罗倩旺','男','13789833453','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND13TNO018','ND13','吴悉挺','男','18062461658','讲师','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND13TNO019','ND13','姚敦','女','15161769154','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND13TNO020','ND13','董迪昌','女','17154617351','讲师','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND13TNO021','ND13','范析书','男','13148454139','讲师','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND13TNO022','ND13','范松晓','男','15200280770','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND13TNO023','ND13','董娟','女','17801361641','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND13TNO024','ND13','戴睿','男','15513221459','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND13TNO025','ND13','陈姣盈','男','15776234503','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND13TNO026','ND13','田文余','男','15916413212','讲师','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND13TNO027','ND13','魏显','女','13219192865','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND13TNO028','ND13','陈明','女','17349210492','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND13TNO029','ND13','杨良','女','17019745998','讲师','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND13TNO030','ND13','陆婉晰','女','17603368895','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND14TNO001','ND14','程睿书','女','15999448526','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND14TNO002','ND14','高明慧','女','13078223953','讲师','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND14TNO003','ND14','刘雨','女','17739031669','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND14TNO004','ND14','钟俊华','男','17917869551','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND14TNO005','ND14','郭轩','女','18314071752','讲师','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND14TNO006','ND14','罗焕瑞','女','13247292897','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND14TNO007','ND14','郭博武','女','13669881958','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND14TNO008','ND14','何雨','女','13846766504','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND14TNO009','ND14','彭婷','男','13109636588','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND14TNO010','ND14','潘轩焕','女','15671185350','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND14TNO011','ND14','董武','男','15928344040','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND14TNO012','ND14','丁轩','女','18594179617','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND14TNO013','ND14','欧阳子','男','17023710959','讲师','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND14TNO014','ND14','阎俊柏','女','17190702296','讲师','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND14TNO015','ND14','蔡析姣','男','15715999885','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND14TNO016','ND14','丁子正','男','18134554284','讲师','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND14TNO017','ND14','沈山睿','男','18885163623','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND14TNO018','ND14','陈正','女','17189766757','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND14TNO019','ND14','丁武','男','18761739808','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND14TNO020','ND14','谭析英','女','13361125001','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND14TNO021','ND14','薛悟','女','13758009401','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND14TNO022','ND14','许析悦','男','15678934671','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND14TNO023','ND14','马余','女','18274069927','讲师','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND14TNO024','ND14','薛婵雄','女','17341569675','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND14TNO025','ND14','欧阳松','女','15648570750','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND14TNO026','ND14','潘思婵','女','18135385879','讲师','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND14TNO027','ND14','刘雨勤','女','17852776056','讲师','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND14TNO028','ND14','梁达倩','女','18028339656','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND14TNO029','ND14','袁婉杰','女','15198755982','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND14TNO030','ND14','胡敦','女','17888951625','讲师','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND15TNO001','ND15','贾俊哲','男','13961703870','讲师','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND15TNO002','ND15','东方义盛','男','18231077840','讲师','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND15TNO003','ND15','苏荣','女','13028150133','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND15TNO004','ND15','叶丰','男','17386665924','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND15TNO005','ND15','贾姣','男','13972012188','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND15TNO006','ND15','叶道盈','女','17898058044','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND15TNO007','ND15','蔡华维','女','18027476239','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND15TNO008','ND15','沈蔼德','女','13135826291','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND15TNO009','ND15','夏思','女','15575060772','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND15TNO010','ND15','戴泽轩','男','17393986362','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND15TNO011','ND15','夏婵','女','17960715957','讲师','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND15TNO012','ND15','萧良仁','女','13431155585','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND15TNO013','ND15','杨轩','女','15727120608','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND15TNO014','ND15','姜婷悦','女','15287366026','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND15TNO015','ND15','姚兰','女','15801324502','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND15TNO016','ND15','邹贤媚','女','13288342780','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND15TNO017','ND15','熊武倩','女','18331386368','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND15TNO018','ND15','张婵','男','15127431491','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND15TNO019','ND15','戴浩婵','女','13527879529','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND15TNO020','ND15','白良','男','13951750672','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND15TNO021','ND15','萧梓山','男','18023835341','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND15TNO022','ND15','叶丰悉','男','18964831774','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND15TNO023','ND15','朱书壮','女','15187540445','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND15TNO024','ND15','蔡涵良','女','17244269561','教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND15TNO025','ND15','曹秀雨','女','13014588113','讲师','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND15TNO026','ND15','唐石','男','15823938207','讲师','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND15TNO027','ND15','郭兰','女','18389960051','讲师','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND15TNO028','ND15','余华巍','男','13635607451','副教授','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND15TNO029','ND15','戴旺','女','13113392955','讲师','7654321AB')
INTO TEACHER(TNO,DNO,TNAME,TSEX,CONTACTNUM,PTITLE,TPASSWORD) VALUES('ND15TNO030','ND15','何文蔼','男','18761588232','讲师','7654321AB')
select * from dual;
/*
        @author: 刘炳锐
        @date: 2021-09-22
        @function:插入教室信息
*/ 
insert all
into classroom values('CR001','普通教室01','软件楼101',60,'空闲','ND04')
into classroom values('CR002','普通教室02','软件楼102',60,'空闲','ND04')
into classroom values('CR003','普通教室03','软件楼103',60,'空闲','ND04')
into classroom values('CR004','普通教室04','软件楼104',60,'空闲','ND04')
into classroom values('CR005','普通教室05','软件楼105',60,'空闲','ND04')
into classroom values('CR006','普通教室06','软件楼106',60,'空闲','ND04')
into classroom values('CR007','普通教室07','软件楼107',60,'空闲','ND04')
into classroom values('CR008','普通教室08','软件楼108',60,'空闲','ND04')
into classroom values('CR009','普通教室09','软件楼109',60,'空闲','ND04')
into classroom values('CR010','普通教室10','软件楼110',60,'空闲','ND04')
into classroom values('CR011','普通教室11','软件楼201',60,'空闲','ND04')
into classroom values('CR012','普通教室12','软件楼202',60,'空闲','ND04')
into classroom values('CR013','普通教室13','软件楼203',60,'空闲','ND04')
into classroom values('CR014','普通教室14','软件楼204',60,'空闲','ND04')
into classroom values('CR015','普通教室15','软件楼205',60,'空闲','ND04')
into classroom values('CR016','普通教室16','软件楼206',60,'空闲','ND04')
into classroom values('CR017','普通教室17','软件楼207',60,'空闲','ND04')
into classroom values('CR018','普通教室18','软件楼208',60,'空闲','ND04')
into classroom values('CR019','普通教室19','软件楼209',60,'空闲','ND04')
into classroom values('CR020','普通教室20','软件楼210',60,'空闲','ND04')
into classroom values('CR021','普通教室21','软件楼301',60,'空闲','ND04')
into classroom values('CR022','普通教室22','软件楼302',60,'空闲','ND04')
into classroom values('CR023','普通教室23','软件楼303',60,'空闲','ND04')
into classroom values('CR024','普通教室24','软件楼304',60,'空闲','ND04')
into classroom values('CR025','普通教室25','软件楼305',60,'空闲','ND04')
into classroom values('CR026','普通教室26','软件楼306',60,'空闲','ND04')
into classroom values('CR027','普通教室27','软件楼307',60,'空闲','ND04')
into classroom values('CR028','普通教室28','软件楼308',60,'空闲','ND04')
into classroom values('CR029','普通教室29','软件楼309',60,'空闲','ND04')
into classroom values('CR030','普通教室30','软件楼310',60,'空闲','ND04')
into classroom values('CR031','计算机教室01','软件楼401',60,'空闲','ND04')
into classroom values('CR032','计算机教室02','软件楼402',60,'空闲','ND04')
into classroom values('CR033','计算机教室03','软件楼403',60,'空闲','ND04')
into classroom values('CR034','计算机教室04','软件楼404',60,'空闲','ND04')
into classroom values('CR035','计算机教室05','软件楼405',60,'空闲','ND04')
into classroom values('CR036','计算机教室06','软件楼406',60,'空闲','ND04')
into classroom values('CR037','计算机教室07','软件楼407',60,'空闲','ND04')
into classroom values('CR038','计算机教室08','软件楼408',60,'空闲','ND04')
into classroom values('CR039','计算机教室09','软件楼409',60,'空闲','ND04')
into classroom values('CR040','计算机教室10','软件楼410',60,'空闲','ND04')
into classroom values('CR041','多媒体教室01','图书馆101',60,'空闲','ND04')
into classroom values('CR042','多媒体教室02','图书馆102',60,'空闲','ND04')
into classroom values('CR043','多媒体教室03','图书馆103',60,'空闲','ND04')
into classroom values('CR044','多媒体教室04','图书馆104',60,'空闲','ND04')
into classroom values('CR045','多媒体教室05','图书馆105',60,'空闲','ND04')
into classroom values('CR046','多媒体教室06','图书馆106',60,'空闲','ND04')
into classroom values('CR047','多媒体教室07','图书馆107',60,'空闲','ND04')
into classroom values('CR048','多媒体教室08','图书馆108',60,'空闲','ND04')
into classroom values('CR049','多媒体教室09','图书馆109',60,'空闲','ND04')
into classroom values('CR050','多媒体教室10','图书馆110',60,'空闲','ND04')
into classroom values('CR051','多媒体教室11','图书馆201',60,'空闲','ND04')
into classroom values('CR052','多媒体教室12','图书馆202',60,'空闲','ND04')
into classroom values('CR053','多媒体教室13','图书馆203',60,'空闲','ND04')
into classroom values('CR054','多媒体教室14','图书馆204',60,'空闲','ND04')
into classroom values('CR055','多媒体教室15','图书馆205',60,'空闲','ND04')
into classroom values('CR056','多媒体教室16','图书馆206',60,'空闲','ND04')
into classroom values('CR057','多媒体教室17','图书馆207',60,'空闲','ND04')
into classroom values('CR058','多媒体教室18','图书馆208',60,'空闲','ND04')
into classroom values('CR059','多媒体教室19','图书馆209',60,'空闲','ND04')
into classroom values('CR060','多媒体教室20','图书馆210',60,'空闲','ND04')
select * from dual;
/*
        @author: 刘炳锐
        @date: 2021-09-22
        @function:插入授课信息
*/
insert all
into teach values('1', 'ND01TNO001', 'J5510N1001', 'CR001', '1:010203;3:060708')
into teach values('2', 'ND04TNO002', 'J8000G0001', 'CR004', '1:0405;4:0102')
into teach values('3', 'ND04TNO012', 'T5130F1001', 'CR006', '2:0304;2:0607')
into teach values('4', 'ND04TNO014', 'T8000C0001', 'CR003', '3:0102;5:0102')
select * from dual;
/*
        @author: 王俊洪
        @date: 2021-09-22
        @function:插入选课信息
*/
insert into select_course(select_no,sno,cno,tno)
select select_no_sequence.nextval,sno,cno,tno from student,teach;
/*
        @author: 刘炳锐
        @date: 2021-09-22
        @function:插入剩下的授课信息
*/
insert all
into teach values('5', 'ND09TNO018', 'J8000G0003', 'CR002', '1:010203;3:010203')
into teach values('6', 'ND04TNO024', 'J8000G0001', 'CR017', '2:0304;5:0102')
into teach values('7', 'ND04TNO028', 'T5130F1001', 'CR001', '2:0102;4:0102')
into teach values('8', 'ND04TNO025', 'T8000C0001', 'CR004', '2:0607;3:0405')
into teach values('9', 'ND01TNO007', 'J5510N1001', 'CR002', '1:060708;2:010203')
into teach values('10', 'ND04TNO010', 'J8000G0001', 'CR031', '2:0405;3:0102')
into teach values('11', 'ND05TNO009', 'T5130F1001', 'CR003', '4:0102;4:0607')
into teach values('12', 'ND04TNO022', 'T8000C0001', 'CR008', '5:0102;3:0607')
select * from dual;
-- 编写函数
/*
        @author: 刘炳锐
        @date: 2021-09-22
        @function:验证学生用户登录
*/
create or replace function check_stu_login
(
       user_name nchar, -- 学生用户名
       user_pwd nvarchar2 -- 学生用户密码
)
return number
authid current_user
is
num1 number;
begin
  select count(*) into num1 from dual where exists(select * from student where sno=user_name);
	if num1=0 then
		dbms_output.put_line('学生用户不存在！');
		return -1;
	else
		select count(*) into num1 from dual where exists(select * from student where sno=user_name and spassword=user_pwd);
		if num1=0 then
			dbms_output.put_line('学生用户密码错误！');
			return 0;
		else
			dbms_output.put_line('学生用户登录成功！');
			return 1;
		end if;
	end if;
end check_stu_login;
/
/*
        @author: 刘炳锐
        @date: 2021-09-22
        @function:验证教师用户登录
*/
create or replace function check_tea_login
(
       user_name nchar, -- 教师用户名
       user_pwd nvarchar2 -- 教师用户密码
)
return number
authid current_user
is
num1 number;
begin
  select count(*) into num1 from dual where exists(select * from teacher where tno=user_name);
	if num1=0 then
		dbms_output.put_line('教师用户不存在！');
		return -1;
	else
		select count(*) into num1 from dual where exists(select * from teacher where tno=user_name and tpassword=user_pwd);
		if num1=0 then
			dbms_output.put_line('教师用户密码错误！');
			return 0;
		else
			dbms_output.put_line('教师用户登录成功！');
			return 1;
		end if;
	end if;
end check_tea_login; 
/
-- 编写存储过程
/*
        @author: 刘炳锐
        @date: 2021-09-22
        @function:录入选课信息
*/
create or replace procedure insert_select_course 
(
       select_sno in nchar,
       select_cno in nchar,
       select_tno in nchar,
       return_result out number
)
authid current_user
is 
num1 number;
begin
  select count(*) into num1 from dual where exists(select * from student where sno=select_sno); 
  if select_sno is null or num1=0 then
    dbms_output.put_line('学号有误！');
    return_result:=1;
  else
    select count(*) into num1 from dual where exists(select * from course where cno=select_cno);
    if select_cno is null or num1=0 then
      dbms_output.put_line('课程号有误！');
      return_result:=2;
    else
      select count(*) into num1 from dual where exists(select * from teacher where tno=select_tno);
      if select_tno is null or num1=0 then
        dbms_output.put_line('教师工号有误！');
        return_result:=3;
      else
        select count(*) into num1 from dual 
        where exists(select * from select_course where tno=select_tno and sno=select_sno and cno=select_cno);
        if num1=0 then
          insert into select_course(select_no,sno,cno,tno)
          values(null,select_sno,select_cno,select_tno);
          dbms_output.put_line('选课成功！');
          return_result:=0;
        else
          dbms_output.put_line('选课重复！');
          return_result:=4;
        end if;
      end if;
    end if;
  end if;
end insert_select_course;
/
/*
        @author: 刘炳锐
        @date: 2021-09-22
        @function:录入评教信息
*/
create or replace procedure insert_evaluation 
(
       ev_sno in nchar,
       ev_tno in nchar,
       evaluation_leve in nvarchar2,
       return_result out number
)
authid current_user
is 
num1 number;
begin
  select count(*) into num1 from dual where exists(select * from student where sno=ev_sno); 
  if ev_sno is null or num1=0 then
    dbms_output.put_line('学号有误！');
    return_result:=1;
  else
    select count(*) into num1 from dual where exists(select * from teacher where tno=ev_tno);
    if ev_tno is null or num1=0 then
        dbms_output.put_line('教师工号有误！');
        return_result:=2;
    else
      if evaluation_leve in('优','良','中','差') then
        insert into evaluation(evno,sno,tno,ev_leve)
        values(null,ev_sno,ev_tno,evaluation_leve);
        dbms_output.put_line('评教成功！');
        return_result:=0;
      else
        dbms_output.put_line('评教等级有误！');
        return_result:=3;
      end if;
    end if;
  end if;
end insert_evaluation;
/
-- 编写触发器
/*
        @author: 刘炳锐
        @date: 2021-09-22
        @function:实现主键select_no的自动增长
*/
create or replace trigger auto_increasment_select_no
before insert on select_course for each row
begin
  select select_no_sequence.nextval into :new.select_no from dual;
end;
/
/*
        @author: 刘炳锐
        @date: 2021-09-22
        @function:实现主键teano的自动增长
*/
create or replace trigger auto_increasment_teano
before insert on teach for each row
begin
  select teano_sequence.nextval into :new.teano from dual;
end;
/
/*
        @author: 刘炳锐
        @date: 2021-09-22
        @function:实现主键evno的自动增长
*/
create or replace trigger auto_increasment_evno
before insert on evaluation for each row
begin
  select evno_sequence.nextval into :new.evno from dual;
end;
/
/*
        @author: 刘炳锐
        @date: 2021-09-22
        @function:实现外键dno的级联更新
*/
create or replace trigger update_dno
after update of dno on department
for each row
begin
  update major set dno=:new.dno where dno=:old.dno;
  update student set dno=:new.dno where dno=:old.dno;
  update teacher set dno=:new.dno where dno=:old.dno;
  update course set dno=:new.dno where dno=:old.dno;
  update classroom set dno=:new.dno where dno=:old.dno;
end;
/
/*
        @author: 刘炳锐
        @date: 2021-09-22
        @function:实现外键mno的级联更新
*/
create or replace trigger update_mno
after update of mno on major
for each row
begin
  update stu_class set mno=:new.mno where mno=:old.mno;
  update student set mno=:new.mno where mno=:old.mno;
end;
/
/*
        @author: 刘炳锐
        @date: 2021-09-22
        @function:实现外键classno的级联更新
*/
create or replace trigger update_classno
after update of classno on stu_class
for each row
begin
  update student set classno=:new.classno where classno=:old.classno;
end;
/
/*
        @author: 刘炳锐
        @date: 2021-09-22
        @function:实现外键sno的级联更新
*/
create or replace trigger update_sno
after update of sno on student
for each row
begin
  update select_course set sno=:new.sno where sno=:old.sno;
  update evaluation set sno=:new.sno where sno=:old.sno;
end;
/
/*
        @author: 刘炳锐
        @date: 2021-09-22
        @function:实现外键termno的级联更新
*/
create or replace trigger update_termno
after update of termno on term
for each row
begin
  update course set termno=:new.termno where termno=:old.termno;
end;
/
/*
        @author: 刘炳锐
        @date: 2021-09-22
        @function:实现外键crno的级联更新
*/
create or replace trigger update_tmno
after update of tmno on teaching_material
for each row
begin
  update course set tmno=:new.tmno where tmno=:old.tmno;
end;
/
/*
        @author: 刘炳锐
        @date: 2021-09-22
        @function:实现外键crno的级联更新
*/
create or replace trigger update_crno
after update of crno on classroom
for each row
begin
  update teach set crno=:new.crno where crno=:old.crno;
end;
/
/*
        @author: 刘炳锐
        @date: 2021-09-22
        @function:实现外键cno的级联更新
*/
create or replace trigger update_cno
after update of cno on course
for each row
begin
  update select_course set cno=:new.cno where cno=:old.cno;
  update teach set cno=:new.cno where cno=:old.cno;
end;
/
/*
        @author: 刘炳锐
        @date: 2021-09-22
        @function:实现外键tno的级联更新
*/
create or replace trigger update_tno
after update of tno on teacher
for each row
begin
  update select_course set tno=:new.tno where cno=:old.tno;
  update teach set tno=:new.tno where tno=:old.tno;
  update evaluation set tno=:new.tno where tno=:old.tno;
end;
/
/*
        @author: 刘炳锐
        @date: 2021-09-22
        @function:自动更新录入成绩时间
*/
create or replace trigger update_input_date
before update of score on select_course for each row
begin
  if :new.score between 0 and 100 then
     select sysdate into :new.input_time from dual;
  end if; 
end;
/
exit;
